Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Unanswered: How to find numeric field in char coloumn

    Hi ,

    I have to select the column where the filed is alphanumeric .More precisely, if I have a column
    Name
    Abca
    Abs123
    Asb1323
    At156bc

    My query should give last three values where the value alphanumeric.

    Please help me.
    TIA
    Vivek

  2. #2
    Join Date
    Dec 2005
    Posts
    273
    Try this:

    SELECT ...
    FROM table ...

    WHERE column ^= TRANSLATE (column , 'xxxxxxxxxx','0123456789' )

Posting Permissions

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