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
--

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase