Subject Substring
Author Roger Pullen
Am attempting to use SUBSTRING in Firebird thus:

P1 = SUBSTRING("ABCDEFG" FROM 1 FOR 5);

as part of an SP. (not as part of a SELECT statment)

Always returns blank

Advice please

Roger P