I recently had an issue when trying to select data from a table. I used an ANY(SELECT( function, which had worked perfectly on several other tables.
In this particular table, however, I was looking to select based on whether a particular text value appeared in a column.
So I was looking for, say, “T5”, in a column with values “T2, T5, T9, T18, T27, T58” using the CONTAINS() function. It wouldn’t do it…it couldn’t “find” the value “T5” in that list, and hence returned the wrong data from the table.
When I replace the T numbers with words, so for example, looking for “Bruce” in the column containing “Adam, Adrian, Bruce, Craig, Dave, Michael”, then it works perfectly, finding “Bruce”, and hence selecting the correct data.
Is this a bug? Or something I am not understanding about the nature of the data?
I managed to make my select function work, but only by replaccing the T numbers with the longer words they were representing. I had to type a lot of words in!