problem med keyword IN i SQL statement

Prøv med WHERE INSTR('3,5,7','5')>0

Hej,

Hvis du skriver WHERE 5 IN (3, 5, 7) er (3, 5, 7) tre tal. Det lyder som om du skulle bruge select INSTR('3,5,7','5') from dual og hvis resultatet er 0 findes den ikke i strengen.

INSTR(char1, char2 [,n [,m]])
Searches Char1 beginning with its Nth character for the Mth occurrence of Char2 and returns the position of the character in Char1 that is the first character of this occurrence.
If N is negative, Oracle counts and searches backward from the end of Char1.  N and M default to 1.