Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: something like an 'is numeric' in the where clause? (was "query help")

    I've got a set of records that has a varchar data type with most of the info being numeric, i.e.

    002563256
    025636982
    000025632

    99% of the data is similar to this but there are a few oddbals with alpha characters:

    a2532222

    is there a way to put something like an 'is numeric' in the where clause?
    Thanks,
    Bill

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by beeyule

    is there a way to put something like an 'is numeric' in the where clause?
    um, IsNumeric()?

    select isNumeric('A123') = 0

    select isNumeric('123') = 1

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •