This is my sample data in a column this is ! Alex23 & and % doing/ *SQL2019 i want this output from above this is Alex23 and doing SQL2019 we are not allowed to use stored procedure and function in organization. we have to type so many update and replace queries, so looking for a better solution which doesn't include so many replace queries.
update tablename set columnname = replace(columnname,'!','') update tablename set columnname = replace(columnname,'@','') update tablename set columnname = replace(columnname,'#','') update tablename set columnname = replace(columnname,'$','') update tablename set columnname = replace(columnname,'%','') update tablename set columnname = replace(columnname,'&','')
select replace( replace( replace('this% contains ! illegal/ chars', '!',''), '%',''), '/','')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)