John's Brain Dump

All the technical gyrations I go through to build software, so I don't forget them and others can benefit from them.

Receive Email Updates

Browse by Tags

All Tags » SQL » Tricks (RSS)
Sorry, but there are no more tags available to filter with.
SQL Trick: Finding Integers in Character Columns
Q: What WHERE condition do you use to find all values in a column that contain only numbers? (No decimal points, no minus signs, just 0-9. A: [ column name ] NOT LIKE '%[^0-9]%' This is the kind of thing that I'll forget a year from now when...
Posted: May 26 2006, 07:38 PM by John | with no comments
Filed under: ,
More Posts