I am getting email id from database but in database some email address are not in correct format. There are millions of record so I cant check every emailID. some emailID has space in last. some has \n character. so I want to how to identify those type of characters with emailID and remove junk characters and get correct emailid value?
Plz help me..
What I have tried:
Select * from table where [EmailID] like '[a-z,0-9,_,-]%@[a-z,0-9,_,-]%.[a-z][a-z]%'
I have tried it but my problem is not solved