Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Coding, syntax & commands
Title:
Searching Delimited String
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only