🚀 go-pugleaf

In article <54nomb$j88@news.NetVision.net.il>
yossik@accentsoft.com (Yossi Konijn) wrote:

To start with the easy question:
To include single quotes use the apostrophe (aka single quote) escape 
char so you would say the following:
   Field1 = 'Can''t'


> UPDATE ServiceRecords 
> SET 
> QueryID = '144', CustomerID='123456789012345',
> EmployeeID='YossiK', ServiceDate = '24/10/96', ServiceTime =
> 'ServiceTime', ProductVersion = '2.0',
> ServiceRecords.ProductName='Dagesh', ServiceRecords.Status='ON',
> ServiceRecords.AnswerDescription='goodbye',
> ServiceRecords.ProblemDescription='hello again?',
> ServiceRecords.Version='2.0' 
> WHERE 
> QueryID='144';  

This looks okay without spending tons o time lookat it. Try using 
Access to check out the SQL.
dave



================================================================
Dave Roth                             ...glittering prizes and
Roth Consulting                     endless compromises, shatter
rothd@roth.net                        the illusion of integrity

****************************************************************
Use of  this message or  email address  for commercial  purposes
(including "junk" mailings) is strictly prohibited and protected
under  current  international  copyright laws  and United States 
Code, Title 47, Chapter 5, Subchapter II.