problem in retriving data from db table.

[Former Member]

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.

[Former Member]

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

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

Rob