Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
DBISAM Technical Support
»
Support Forums
»
DBISAM SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Removing non-numeric characters from a database field
Sun, Aug 17 2014 9:49 PM
Permanent Link
Mark Shapiro
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
Mon, Aug 18 2014 1:58 AM
Permanent Link
Roy Lambert
NLH Associates
Team Elevate
Mark
Try something like
select _type from records
where
_Type is not null
and
cast(_type as integer) IS NULL
Roy Lambert
Thu, Aug 21 2014 9:06 AM
Permanent Link
Mark Shapiro
Roy,
Beautiful. Thank you.
Mark Shapiro