Advanced Search

Return to Snippet

Revision: 27704
at June 21, 2010 19:50 by mprabhuram
Initial Code 
CASE
    WHEN REGEXP_LIKE(MASTER.LOANNO,'[^[:digit:]]') THEN NULL
    ELSE
        TO_NUMBER(MASTER.LOANNO)
END AS ACCT_NBR,
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This will take the alpha numeric loan number field and converts it into numeric loan number. If there are any loan numbers with alphabet then it is converted as NULL  (basically alpha numeric loan numbers are ignored)

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Regular expression to convert alphanumeric field into numeric field

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL