Try someting like this
lcMynumber = "1"
WHERE "," + lcMynumber + "," IN ",1,2,3,4,5,6,7,8,9,"
>I have a delimited string:
>
>"1,2,3,4,5,6,7,8,9"
>
>And at another time it is:
>
>"2,3,4,5,6,7,8,9,10"
>
>A view that is based on records matching the appropriate number found in the string (using IN condition) works great except when the number is "1" and then it will return True for both strings even though I want it to only return for the first one. No brainer; the "10" in the second one is causing this. It is a problem to manipulate the value being compared to the string (converting it to "01" for examle), so I was hoping someone had a simple way to still use "1" to compare and return True only in the first case. Thanks!
>
>Regards, Renoir
--sb--