I'd appreciate any advice on constructing an SQL statement to delete any records in a DBISAM field that contain a non-numeric character. Thanks in advance.

Mark Shapiro
infocus@swbell.net

Mark


Try something like

select _type  from records
where
_Type is not null
and
cast(_type as integer) IS NULL


Roy Lambert

Roy,

Beautiful. Thank you.

Mark Shapiro