Lets say that I have 100 names starting Ad.For example "Adam".
I want sql to find all the values starting with Ad and replace "Ad" with "Fo" just in one attempt for all 100 names.Plese if someone know I would be very glad to hear answers.Thanks in advance