John Jason Jordan wrote:
That solved the problem. I tried wildcards but they didn't work.
However, after reading what you said I tried again. It turns out that
the wildcards do work if they are _inside_ the single quotes, e.g.,
LIKE '*stringvalue*'. I had them outside the single quotes.
That leads me to another issue - what if the string that I am selecting
on contains a ? or a *?
Thanks!
Never tried this with SQLite ( and never say anyting works I have never
tried )- but in most SQl dialects and with most Base - you need to
precede the wild card character with an escape character - and you
define the escape character right in the command.
So to find all instances where a column contains an * you could use
LIKE '*\**' escape '\'
Here I have defined the escape character to be \
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
