> > In Delphi index starts at 0.
>
> Er, not really.
> Text := 'Hello';
>
> In Delphi:
> copy(Text, 2, 1) -> 'e'
>
> In SQL:
> substring(Text from 2 for 1) -> 'e'
>
>

Thanks for refreshing my memory:)
and thanx for the quick solution as well...;)