Hi , I have A nvarchar value Like This =id1-1,2 ; id2-1,3 ; ....... Id value ---------- id1 abc id2 bcd id3 cdf now i want nvarchar value abc-1,2;bcd-1,3; i want return the nvarchar value with replace of id1,id2 values(i have a table id,value)
update mytable set id = replace(id, 'id1', '')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)