Subject Re: [firebird-support] Re: Length of String < 10 in SQL Statement - how?
Author Magnus Titho
hi_feroz schrieb am 27.01.2005 09:43:

>
> can u translate this - substring(BAR_CODE from 10 for 1) = '' in
> plain english - how does it work? it starts from position 10, checks
> a string at this position and returns it -> loops until position 1.
> Is it?

No, it gives back a partial string starting at position 10 and of length
1. If the column-text has 10 or more characters, it should return just
the one character at position 10.
(In Delphi: copy(Text, 10, 1))


Magnus