Find more than 1 alphanumeric chars in a string

[lavadan]

I have an employee name table

Surname GivenName
ABC x.yz
ABc x.y.z
ABC X.*YZ
A*.BC xyz

The query needs to get me the surname and givenname which have more than 1 non alphanumeric characters together(one after the other). In this case the output will be

abc x.*yz
a*.BC xyz

How would I find just the names that have 2 non alphanumeric chars together(one after the other). If they are not continious (x.y.z) then I would not need them.

 

[fredericofonseca]

select * from xxx where field like '%[.*/?][.*/?]%'

add all the chars you wish to find between the 2 blocks of brackets - take in consideration that some chars will need to be escaped

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886