Comments by harshitawkk (Top 5 by date)

do you know how to write query ?

this process i'm aware off

then the query will overwrite this value

how should i use this
var res = "1111" + TAX_ID.Substring(4);

can you please help me with complete query and how will this mask my 1st 4 digit of existin value

UPDATE table
SET TAX_ID = replace(TAX_ID, '4', '1111')
WHERE TAX_ID NOT LIKE '%MIS%';
this will add 1111 in existing value .


i need to mask 1st 4 or 5 digit from the value

output should be 111119999