I have defined a user-defined function in sql server 2000 that returns a table with multiple columns, all containing quite long strings. I defined the return values to be e.g. varchar(2000) or even text. It works nicely, but all characters beyond the 255est are cutted! So the resulting column contains max. 255 characters - no matter what data type I used! I get no error messages in those cases - unless I defined a (smaller than 255) varchar(254) and tried to return a longer string... Can't be a driver problem, as this even shows within views in Enterprise Manager. Any help is very welcome!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
User defined function only returns max. 255 chars?
- Thread starter cvmandach
- Start date
- Status
Similar threads
