465789psw
Hall of Fame
Points: 3314
More actions
August 18, 2004 at 12:54 pm
#161406
Is there anyway to do
where table.col LIKE IN ('DOG%', 'CAT%,',GOAT%)
THANKS
Antares686
SSC Guru
Points: 125444
August 18, 2004 at 1:50 pm
#519643
No not like that. Just
col like 'x%' OR
...
However if it is a large list you could dump each to a table and join this table to the table in question and try
FROM myTable M INNER JOIN likeTable L ON M.col LIKE L.col + '%'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply