Recent content by harshitawk

I'm not very sure what is the yor question all i need is to mask the 1st 4 digit and output should be 11119999 instead of 99999999

why is this column serving double duty? BecauE for some customer I don’t have number so for missing value m using MIS Further, why are you mixing text and numbers in it? For missing value we are using MIS . Further, what your ultimate aim? If I have 999999999 as customer number then all I...

Hi , I need assistance here for updating 1st 4 digit of a column value for E.g i have value 999999999 (9 digit) and i need to mask 1st 5 digits with 11111 output should look like "111119999" However, in the same column i have value called "MIS" i dont want to touch those value what query...