JackBurton07
IS-IT--Management
Hi I want to write a query that will fix names with apostrophes like O' and Mc
For example I want to :
Convert all surnames in my table beginning with “O Name” to “O’ Name“.
I also want to fix all surnames beginning with “McName” to “Mc Name” (where Name represents a surname).
Help!
For example I want to :
Convert all surnames in my table beginning with “O Name” to “O’ Name“.
I also want to fix all surnames beginning with “McName” to “Mc Name” (where Name represents a surname).
Help!