Click on the link below then install SQL BOL In the Index, type in: VARCHAR and it will tell all.
Namely, VARCHAR has a limit of 8000 characters. While you are there, at the bottom of that page you will see a link to "Data Types" Click it and read on... David L. Penton, Microsoft MVP JCPenney Technical Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: M. H. K. [mailto:[EMAIL PROTECTED]] Thanks. I got a statement like this. CREATE TABLE tblRec ( recID int IDENTITY(1,1), recName varchar(50), recMessage ?????, recFrom varchar(50), recTo varchar(50), recDate date, recURL varchar(255), recArticleID int, recMediaID int, recPickedUp smallint, ) Could you help me with the following question ? How do I make the recMessage to store more than 255 characters ? Would varchar 300 work ? or what's the ACCESS's memo correspondence in SQL ? --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
