topic problem in retriving data from db table. in Application Development and Automation Discussions

problem in retriving data from db table.

Former Member — Tue, 11 Sep 2007 17:16:51 GMT

dear all,

f i hve to retrive field from db table,but problem is that in that table only one input field is present and second field is not present.but i have to compare with tht second field as well as second field.how i should fire a query in comperision to tht second field.

Re: problem in retriving data from db table.

Former Member — Tue, 11 Sep 2007 17:29:19 GMT

Assuming the second field is a character field, try something like:


SELECT * FROM mytab
  WHERE f1 = whatever
    AND f2 = SPACE.       "<==========

Rob