Thanks Igor :) -----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 2:14 PM To: SQLite Subject: [sqlite] Re: How to escape % chars?
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
