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

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


Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard