asked on
Declare @str nvarchar(1000)
set @Str = 'Process of submitting the bill id: AS12345 is send back to Customer. Bill id:WE23456 and Bill id: AS12345 came from customers'
Declare @t table (billid varchar(100))
Insert into @t values ('AS12345'),('WE23456'),('AS12345')
select distinct billid from @t