I am using a program called a/egis, a sybase database. When I try to
paste notes into the ``notes`` from an .asp web page from which I
copied (using (cntrl-c) onto the clipboard  I get the following error
when I try to paste it(using cntrl-v)into A/egis.

-2147217900 : [microsoft][odbc sql server driver][sql server]Incorrect
syntax near 'S'.
[microsoft ole db provider for odbc drivers]
-2147217900 : [microsoft][odbc sql server driver][sql server]Unclosed
quote before the character string ',getdate[]]'.
[microsoft ole db provider for odbc drivers]

INSERT INTO TNOTE [CLM_OFFICE_CD,NOTE_KEY1,NOTE_KEY2
NOTE_TYPE_CD,NOTE_CREATE_DTTM,NOTE_TEXT,NOTE_SEQ_NO,USERID_CD,SOURCE_SYSTEM_ID,TIMESTAMP]VALUES['999001','001209253','B','02','2001-10-19
17:37:06','EMS TO BE PRESENTED TO THE WARRANTY COMPANY. TAKE A PHOTO
VERIFYING SHOP'S LABR RATE. VERIFY THE FRONT DRIVE SHAFT US SEUZED AT
FRT JOINT AND IS CAUSING A FRT END NOISE. VERIFY ANY RUST/CORROSION ON
UNDERCARRIAGE OF VEHICLE. VERIFY ALL FAILURES WITH PICTUR',
4,'ddriesse', 'AE',getdate[]]

Any ideas on where the problem is?

Thanks in advance, Dave

Not being near a SQL Server I can try it BUT,
In the body of the text you have ...VERIFYING SHOP'S LABR ...
That apostrophe in the word shop might not be helping !!
Try it again without.

NOTE_TYPE_CD,NOTE_CREATE_DTTM,NOTE_TEXT,NOTE_SEQ_NO,USERID_CD,SOURCE_SYSTEM_
ID,TIMESTAMP]VALUES['999001','001209253','B','02','2001-10-19

Yeah, it's definitely the apostrophe that's doing. If you double it up
(SHOP''S), you should be OK.