Re: Seeking an SQR 'In' function

[Jason Wainwright <JasonW@LIMON.CO.ZA>]

" From: Ivory, Wayne [mailto:wayne.ivory@ILUKA.COM]
As you know in SQL you can have a condition such as:
        WHERE ERNCD IN ('REG','OVT','TRV',...)
The other day I was modifying an SQR that had a variable $Erncd that I
needed to test for over 20 distinct values."


Hi Wayne
I use Sybase and can get the above functionality.
But if U can't, U could try a loop that dynamically changes the where clause
(i.e. [$where_str] ), or U could try a begin-sql and use a programmatic sql
statement, or use a stored proc.