I have this problem. I have designed a table to store long message or remark, where these info are more than 1000 characters. When I use store procedures to assign these info into a parameter/variable (where I declared it as @str varchar(1000)), it's only return first 250 characters of remark or message? The rest of the characters are all truncated. WHy? Pls help me. Thanks in advance.