Drew Jensen wrote:
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 \
FYI - I double checked the use of escape coding is covered in the help
file so F1 is your friend here, and they show the use of curly brackets,
which IIRC you may need to use for the ODBC connection youa re using.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
