Hi Team,
How do I find/test if a field called Status has its value contained in a string like 'CA;CO;CL'?
IN won't work, it wants something like ('CA',CL','CO').
CONTAINS is no good.

Regards & TIA,
Ian

Yeah!  Isn't always the way....
As soon as I raised the Question I came across Occurs().
Sigh!

All good now.

Thanks for looking.
Ian

Ian


For future reference I use POS.

Roy Lambert

Noted.  I didn't get that far in the alphabet.  

Ian

Couple of things:


Whilst I doubt you'd notice any speed difference with the length of string you're liable to be using, and unless its hitting loads of rows remember POS returns as soon as it finds a hit, OCCURS has to check out the full string every time

Second whichever way you go, unless you can guarantee uniqueness of substrings in the string always append the separator to the row you're testing

silly case test for 'co' in 'coa;cob;coc' would show true but test for 'co;' and it will return false

I been bitten by that a few times.

Roy Lambert

Hi Roy,
Noted.  Fortunately they are all unique.

Regards,
Ian