Re: Transform text for IN clause?

bd wrote:

> 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

This is c.d.oracle.server. What database is it you think this code will run on? Certainly not Oracle.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)