mcromarty - Thursday, June 14, 2018 9:10 AM
See the below illustration:
create table punch
(
word varchar(200)
);
insert into punch values('Acme Products, Inc.');
select * from
(select replace(replace(word,',',''),'.','') as word from punch
)rep
where word='Acme Products Inc'
Saravanan