How to keep more than 255 chars?

[mkuan]

Hi, all. Happy new year.

In SQL Server 6.5, I would like to create a sproc that has an input parameter. When using the sproc, I want to be able to send a string that's more than 255 characters to it. As far as i know, Char and Vchar are the 2 data types that accept characters, and of the two, Vchar can take up to 255 characters, anything after that is truncated.

What if I want to send a string that's longer than 255 (say 1000) to the input parameter and not get the string truncated? Can someone tell me how to solve this problem?

TIA.


Min.

 

[RickCole]

If you need to have a field of more then 255 characters in 6.5 you need to use the data type ‘text’.

Rick.