Trying SUBSTRING on Firebird thus

P1 = SUBSTRING("ABCDEF" FROM 1 FOR 4);

will not even compile. P1 is a previously
defined variable (It is part of a SP.)

Thanks

Roger P