Subject substr(s,m,n) caused arithmetic exception, numeric overflow, or string truncation
Author vmddtech vmdd
Background: FB 1.5 RC6, Windows 2000.

I have table news where txt is a column defined as
varchar(255).

When issuing the SQL:
select substr(txt,1,2) from news;


Then, I get the mentioned error. I am certain that
all txt rows contains enough text (20 characters or
more).

Ben


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree