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?