Subject Re: [ib-support] SQL select help.
Author Paul Reeves
mivi71dk wrote:
> Hi
> I would like to make a SQL Statement like:
> Select * from TABLE1 where Field1="The first 8 charaters from another
> field"

Firebird has

SUBSTRING( <string expr> FROM <pos> [FOR <length>])

See page 10 of the release note for full documentation.


Paul Reeves
Supporting users of Firebird and InterBase