Forums

This topic is locked

Select SQL using LIKE condition

Posted 13 Aug 2007 09:09:23
1
has voted
13 Aug 2007 09:09:23 aparna agarwal posted:
i am using the following sql -

SELECT * FROM Change_Requests where TARGET_ID LIKE 'WEN_WEN',

but since the id has _ part of its name, it returns all results such as WEN-WEN as well...

is there a way i can prevent _ being used as a wild card character?

Reply to this topic