Results 1 to 10 of 10

Thread: [RESOLVED] Oracle Equivalent of IsNumeric

Threaded View

  1. Dec 7th, 2009, 03:29 PM #1
    brucevde
    brucevde is offline

    Thread Starter
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Resolved [RESOLVED] Oracle Equivalent of IsNumeric

    I have this query I use against SQL Server that I need to execute against an Oracle database.

    I can't find an equivalent Oracle function for IsNumeric.

    Code:
    SELECT  
     CASE WHEN IsNumeric(SubStr(PERSON.NAME_FULL_FORMATTED,1,1)) = 1 Then  
        PERSON.LASTNAME + ', ' + PERSON.FIRSTNAME
     ELSE
        PERSON.NAME_FULL_FORMATTED
     END
    I use this web site for help on writing Oracle queries, maybe it is outdated.
    http://www.techonthenet.com/oracle/f...ndex_alpha.php
    Last edited by brucevde; Dec 7th, 2009 at 03:32 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width