Re: Inserting a string with an Apostrophe

From: CB (anonymous_at_discussions.microsoft.com)
Date: 04/30/04 

Date: Thu, 29 Apr 2004 18:26:05 -0700

Let me try to explain:

I am compiling information about tenants that is stored in a few different tables and populating a new table with the gathered data. So the processes is as follows -
1. read in a record from the SourceTable
2. assign the variables
3. write the data into the DestinationTable using the assigned variables

So the Names are coming from an existing table. I can not easily change D'Angilo to D''Angilo.

Thanks again for your help.