Forum Stats

  • 3,770,576 Users
  • 2,253,136 Discussions


Get Result of only Non Alphanumeric Values including spaces

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.

Appreciate if anyone could help me on this.

Thanks in Advance.