Select * From <table> Where <textfield> like ',@%'

[charmedcharmer]

Hi, I'm trying to do query using this script:

Select * From <table> where <textfield> like ',@%'

the problem is that no record is being retrieved. Is there a way for me to search for special characters on textfields? Thank you very much

[Shuja Ali]

have you tried this
Select * From <table> where <textfield> like '%,%@%'

[charmedcharmer]

It somehow works but unfortunately it doesn't display the data that I need. What I need is to query all records from that table based on the textfield with the starting text of the field is ",@'.

Your script does something else that I can't explain in words. Im sorry

[Shuja Ali]

What I need is to query all records from that table based on the textfield with the starting text of the field is ",@'.

Then your original query will work properly.
Select * From TABLENAME Where FIELDNAME Like (',@%')

Your script does something else that I can't explain in words. Im sorry

The query posted in my previous post will search all the records which contain , or @ in the field.

[Ecniv]

You haven't stated what db you are using. Check it help files. There is usually an escape charact you can use before special characters. I think it is \ or / (can't remember which).

If you look up the help files on like operator it should mention something there. Or search escape characters online?