SQL 2000 varchar data type

[A@Rome]

Hi all,
I've declared a varchar(8000) var but when I select the variable I've only 256 characters.
Strange is that if I select the length of the variable the result is greater than 256...
I'm using SQL 2000 and SQL 2000 client so there should not be problem related to SQL server 6.x
Someone can help me?
Thank you very much

[YuckFou]

In SQL Query Analyzer click Tools.Options (CTRL+Shif+O) and on the tab Results increase "Maximum characters per column"

[A@Rome]

Thank you very much, the length of the varchar variable could be an issue when using the execute(string) function?

[YuckFou]

as far as I know there is no issue with executing (long) string. also you can execute more strings..
execute(string1+stringN)

[A@Rome]

thank you very much!