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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Return the longest lenth of a fields as output ?

Author  Topic  jhsong Starting Member 2 Posts Posted - 2001-02-28 : 14:48:30 I have table called 'customer' In customer table, there are several fields (Company Name, last Name, first Name, etc...,) When I tried to return companyName, it returned companyName with the fixed length. I mean even though the longiest companyName length is just 40 characters, it returns 40 characters(Real companyName) and plus the 88 length blanks. I want to returns just 40 length of companyName without extra blanks so that client side display just as I returned to them.