| Subject | RE: [firebird-support] LIKE clause trough ODBC: expression evaluation not supported (SOLVED!) |
|---|---|
| Author | Steffen Heil |
| Post date | 2004-06-26T19:31:59Z |
Hi
AND Fld3 STARTING WITH ?
IF ? does never contain any %.
This will also speed up your query, as firebird will be able to use indices.
Regards,
Steffen
> AND Fld3 LIKE ? + '%'Use
AND Fld3 STARTING WITH ?
IF ? does never contain any %.
This will also speed up your query, as firebird will be able to use indices.
Regards,
Steffen