in

Hydrus Software Forums

Discussions about Hydrus Software Products
All Tags » Tricks (RSS)

Browse by Tags

  • 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 I need it again. UPDATE: 7/11/06 I ran into the...
    Posted to John's Brain Dump (Weblog) by John on 05-26-2006
Page 1 of 1 (1 items)
Copyright Hydrus Software, 2007. All rights reserved.