I did this. Yes, there is a very simple way.
myvalue = "1"
searchstring = "1,2,4,5,10"
"," + myvalue + "," $ "," + searchstring + ","
Regards, Hilmar.
>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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)