Query

How to get all rows from a table which are having special characters in its data

You can query in the normal

You can query in the normal way but open the details in notepad++ (or similar tools) where you can read the special characters.