Hi all,
I have a requirement to select record from databas table based on the Text.
ie.,if table has,
record1--> rahul kumar
record2--->mark spencer
Select ... from <D/B table> where <Field> = 'rahul'.
It should pick "record1".
Select ... from <D/B table> where <Field> = 'spencer'
It should pick "record2".
But i am not getting how do we write the where condition.
Where <Field> LIKE 'rahul'. wont work as it is looking for exact name in table, like 'rahul kumar'.
Can anyone help me here?
Cheers,
Rahul.