On Oct 7, 2005, at 10:21 PM, Joe Noon wrote:
I need to find all records where login has an underscore in them. I know it has something to do with ESCAPE, since _ matches a single character, but I cant seem to get the syntax correct. Here is what im intending to do, even though this obviously doesnt do it: SELECT * from users where login LIKE '%_%';
SELECT * FROM users WHERE login LIKE '%\_%' ESCAPE '\' note: you can use an escape char of your choice. -- Puneet Kishor