This may sound like a "kluge", but what I do is change the apostrophes to ` (I call it the backwards apostrophe since I don't know it's proper name. It is found next to the 1 key. I, too, have always struggled with the double quote as a string delimiter, and an apostrophe as an allowable alternative. What do you do when the apostrophe is part of the data. My kluge takes care of it and nobody ever really notices. For instance, O'Neil and O`Neil look almost identical. Try it. Jerry ----- Original Message ----- From: "Casey Crookston" <casey at thecrookstons.com> To: <thelist at lists.evolt.org> Sent: Monday, July 14, 2003 7:40 PM Subject: Re: [thelist] Re: Adjusting strings for SQL > I now have the same problem but in reverse: A record in the db contains the > data "Gold's Gym." When I load this record into a recordset and display it, > it shows as "Gold". > > At what point do I work with the appastrophe to keep it from dropping? > > Thanks, > > Casey > > -- > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > Evolt.org conference in London, July 25-27 2003. Register today at http://evolt.org.uk > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt !