> Dear Expert,
>
> Searching for a string in a field.
>
> If a datafile (i.e. search_cur) has a field on qualification(s) (i.e. qualif) with a string 'degree', how do you search for the string within the field and send the output to a cursor
>
>
> Thabks
Derek
I prefer LIKE to $ as it is SQL compliant
SELECT * from datafile where lower(qualif) like '%degree%'
If it is a user enter value
SELECT * from datafile where lower(qualif) like '%'+lower(lcUserValue)+'%'
Regards
Tushar