change name to *

[d4rlie891]

Hi,

I want to change the Name start from the 4th Char with *, is there any way to do that?

for Example :

Name :MICHAEL JACKSON

New Name : MIC************

Thanks

[HirisH_V7 · Accepted solution]

Hi,

Check this

Left(Name,3) & Repeat('*',Len(Name)-3) as New

-Hirish

[d4rlie891]

Thank a lot for your Help