This query may not be efficient but hope it will give an idean for want you are looking for

Code:
SET DEF OFF

SELECT id, name FROM test
WHERE (name LIKE '%$%' OR
name LIKE '%&%' OR 
name LIKE '%*%' OR
name LIKE '%@%' OR
name LIKE '%!%' OR
name LIKE '%#%' OR
name LIKE '%^%' OR
name LIKE '%~%' OR
name LIKE '%`%' OR
name LIKE '%)%' OR
name LIKE '%-%' OR
name LIKE '%+%' OR
name LIKE '%:%' OR
name LIKE '%/%' OR
name LIKE '%(%')

Put all wild characters in OR condition....

HTH

Sameer

[Edited by Sameer on 09-09-2002 at 11:45 AM]