On 06/19/02 16:47:19 +0200 Andreas Pohl <apohl@...> wrote:

>> Is there a way to have a parameter for an 'in' clause that expands to a
>> string?
>
> I solved that with help of a small udf:
>
> select * from t_table t where
> f_ibpparseint(t.artikelnr,:artikel)=1 and
> f_isparentstr(:stichw,(select stichwort from t_artikel a where
> a.nr=l.artikelnr))=1
>
> e.g. f_ibpparseint( 1 ," 1 , 2 , 3 ") returns 1
>
> e.g. f_ibpparsestr( "TEST" ,"IBO , DELPHI , WORLD ") returns 0

Thanks, that sounds like a very good idea! Adding to the SQLWhereItems (as
suggested in another answer) wasn't really to my liking because the query is
in reality a little more complex than the simple example I gave and that
would have been a lot of fuzz.


Oliver Sturm

--
Fa. Manfred Dahlhoff - Buellenkothenweg 37a - 40229 Duesseldorf
Tel.: 0211-2202821 - Fax: 0211-2202822 - http://www.Manfred-Dahlhoff.de