I have 3 columns in my database tables. Candidate Name, First Name, Last Name. I wanted to find out if there are any Non Alpha Characters in Last Name Column and display them. Can someone please help me to write query on this.
Eg : Candidate Name First Name Last Name
John, Regis John Regis
Anthony , . Anthony .
Christine, , Christine ,
I need o/p of Anthony and Christine since they have Non Alpha Characters.. what should I write in where condition? It can also include space too.. I'm using Toad for Oracle to write the Query.
Please suggest me.