Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dsetzer
Starting Member
31 Posts |
 Posted - 2001-07-03 : 11:43:38
|
| I have a table in my database that contains a Notes field which is a varchar, size 1024 field. When I do a select from it in Enterprise manager, I can see the full contents of the field. When I do a select from it in Query Analyzer, only the first 255 characters are returned. When I do a select from it in ASP, only the first 255 characters are returned.The strange thing is, our development SQL Server doesn't behave in the same way. The select from it in ASP returns the full field's value, not just the first 255 characters.Any ideas are greatly appreciated. |
|
|
|
|
|
Problem with varchar(1024) field