Hi people.

I have a sql statement like this

select checkno, cast(checkno as bigint)
from payment

My problem is that some value in checkno contains non numeric
characters. how can I tell the Firebird to skip those records which
contains non numeric charaters in order to prevent the avobe sql
statement to give error message?

Please help. Thanks a lot.


regards,
james