Finding the word in a String

Conkyman

New Member
I have a field in the sql server 2000 table which is UserUnderTakeID(varchar).<BR>Lets say one of the value is this '34,23'<BR><BR>Now i want to use an SQL Statement to extract all the values which has a UserUnderTakeID of 3. I tried to use InStr but the problem is the above value '34,23' was also taken out becasue of the number 3 in them but i do not want that record becoz it is actaully 34 and 23. If the field is 3,12 then this record i want it. Is there any SQL Statement that can do this? Thanks :DVery Sorry
 
Back
Top