SQL Server: How to Get Strings Which Contains Special Characters

Recently I was asked for a T-SQL by using which, one can get string data, which contains special characters. There are situation when existing client data is need to be merged into your newly build system and existing data may contain strings with special characters like !,@,#,$,%,^,&,*,+ etc, which can crash your application.