This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C19FAE.9F101CE6
Content-Type: text/plain


Assuming SQL Server 7+ 8060 characters. This is the maximum number of bytes
for a row in SQL Server, so if you wanted other fields (an ID for example)
you would need to cut that size.

regards
David Cameron
nOw.b2b
dcameron@i...

-----Original Message-----
From: Dean [mailto:spinout@i...]
Sent: Friday, 18 January 2002 9:34 AM
To: sql language
Subject: [sql_language] What is the maximum characters allowed in
varchar(?)


Just a quick one, I was wondering if anyone knew what the maximum number 
of characters is that you can assign to a column using varchar.

Oh and does anyone know how to get around the problem with SQL errors when 
a user enters the ' character anywhere on a form?


$subst('Email.Unsub').