Tope Akinniyi wrote:

> 1. Please what function can I use to convert a string to integer (or numeric generally)?

Where do you want to use it?
Why do you want to use it?
Display functions would depend on your client, 'string' are
automatically converted to numbers if required in the SQL. Perhaps with
the help of a CAST( x AS INTEGER ), but that is getting 'specialist'

> 2. Some of the functions listed in InterBase Documentation are not applicable to Firebird (eg, SUBSTR). Please can anyone point me to any URL where I can get the list of Updated Functions tolerated by Firebird?

The release notes are fairly complete, SUBSTR is SUBSTRING as per SQL
standard. ( SUBSTRING( X FROM 1 FOR 6 ) )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services