Originally posted by irehman
Yes, I thought of that but in some cases Invalid Characters also have Spaces , it is big mess.
What do you mean space...

I did following ..wild characters also has spaces...

Code:
SQL> SELECT * FROM wildchar;

        ID NAME
---------- --------------------------------------------------
         1 sasas $ asa as
         1 sasas ! asa as
         1 sasas!asa as
         1 sasas&asa as
         1 sasas°asa as
         1 sasas+asa as
         1 sasas~asa as
         1 sasas*asa as
         1 sasas * asa as
         1 sasasas
         1 sasasasasasasas
         1 sameer
         1 sam $ sas ( sas

13 rows selected.

SQL> SELECT id, name FROM wildchar
  2  WHERE (name LIKE '%$%' OR
  3  name LIKE '%&%' OR
  4  name LIKE '%*%' OR
  5  name LIKE '%@%' OR
  6  name LIKE '%!%' OR
  7  name LIKE '%#%' OR
  8  name LIKE '%^%' OR
  9  name LIKE '%~%' OR
 10  name LIKE '%`%' OR
 11  name LIKE '%)%' OR
 12  name LIKE '%-%' OR
 13  name LIKE '%+%' OR
 14  name LIKE '%:%' OR
 15  name LIKE '%/%' OR
 16  name LIKE '%(%');

        ID NAME
---------- --------------------------------------------------
         1 sasas $ asa as
         1 sasas ! asa as
         1 sasas!asa as
         1 sasas&asa as
         1 sasas+asa as
         1 sasas~asa as
         1 sasas*asa as
         1 sasas * asa as
         1 sam $ sas ( sas

9 rows selected.
Sameer