How to handle name with apostophe in it.

mgmhicks used Ask the Experts™
I have a this name d'Angleo that has to get updated to a sql database table.  Is their a script to run on these type of names to handle the apostophe in a name.  A example would be great.

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
not sure what exactly is your requirement, but to reference to the aposthrophe just use two consecutives quotes. so:

update yourtable set yournamecolumn = 'd''Angleo'

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial