Search results

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...