On 23 Apr 2002 at 12:44, Helen Borrie wrote:

> At 02:20 PM 23-04-02 +1200, you wrote:
>
> >Rows? I think you've overlooked function SUBSTRING.
>
> Erk, sorry...
> but the same applies: position starts at 1, not 0.

Another problem with substring, if I do
select substring ('Sandeep' from 1 for 2) from rdb$database
I get 'Sa'.

But if I do the same thing in Stor Proc where I pass the name a s parameter I get
'a'


Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz