SQL servicer script, data type for MEMO

[DH]

Hello All:

I am working on a VB(6.0) project which load data into a SQL Server (7.0)
database. I wrote a SQL script to Create_Table on the database. What data
type I can use for a "memo" field on a table? I used verchar (255) but it
was too small to hold data on the field.

Thanks in advance,

DH

[vishgr8]

Hi !!!!

The Equivalent data type in SQL Server 2000 is NTEXt.

Size of varchar can go upto 8000 so you can always use varchar(8000).

Problem with using NText and TExt is that while one cannot use it relational operators with it.....

[vishgr8]

Hi !!!!

The Equivalent data type in SQL Server 2000 is NTEXt.

Size of varchar can go upto 8000 so you can always use varchar(8000).

Problem with using NText and TExt is that while one cannot use it relational operators with it.....

go through this website

http://www.microsoft.com/technet/pro...rt2/c0561.mspx