[sqlite] Re: How to escape % chars?

[Igor Tandetnik]

André Goliath <[EMAIL PROTECTED]>
wrote:
sorry for that dump question, but how to escape % chars in a column
LIKE '%the income was 50%%' statement?
I want the second % threated as regular character and the first and
last % as wildcards.

field LIKE '%the income was 50\%%' ESCAPE '\'

Any character can be used as an escape, it does not have to be 
backslash.

Igor Tandetnik