| Subject | Re: [firebird-support]escaping LIKE wild cards |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-06-20T20:40:46Z |
Nathan Jobe wrote:
where xyz like '#%1' escape '#'
That's equivalent to
where xyz = '%1'
Regards,
Ann
>The SQL LIKE operator includes an optional escape clause:
> How do you add a literal % sign to your SQL queries and not have it take as
> a wildcard ?
where xyz like '#%1' escape '#'
That's equivalent to
where xyz = '%1'
Regards,
Ann