How is this..,
TableName : CUSTOMER_MASTER
column name : FIRSTNAME
one row in my table has value "RA%JESH"
Now this is my Query
select * from CUSTOMER_MASTER cm where replace(cm.FIRSTNAME,'%','~') like '%~J%';
Added for Text datatype
select * from CUSTOMER_MASTER cm where replace(convert(varchar,cm.FIRSTNAME),'%','~') like '%~J%'
Let me know if it's helps you
Thanks & regards
Rajesh B