Re: Transform text for IN clause?

You could write a function like...

• pseudo code create function udtTheFunction( @variable varchar(1000) ) returns @valuesTable table ( aValue varchar(50) ) as begin while (get position of character) begin insert @valuesTable values( @strValue ) find next character end

  return
end

your select could be:

SELECT * FROM x
  WHERE c IN (SELECT * FROM udtTheFunction(@variable))

Bryce Received on Wed Mar 09 2005 - 08:25:22 CST