In sql server, can try with replace function in your query.