Skip to Content
0
Former Member
May 14, 2010 at 11:06 AM

Select record based on the Text

28 Views

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.