Like: ``` sql select * from animaltype where races contains (name.toLowerCase().subString(0,1) = 'e') ``` It is similar to `IN` operator.
Activity
mathiasrw commentedon May 25, 2015
I might dont get the picture here - but looks to mee like the example is trying to assign 'e' to a string
anyway. Might not be important that I dont get the example. The CONTAINS looks useful and is well described here
https://msdn.microsoft.com/en-us/library/ms187787.aspx
mathiasrw commentedon Jul 14, 2015
This should be a small change to the parser
renxida commentedon Aug 8, 2017
Bumping issue. I find myself needing this too.