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
 Transact-SQL (2000)
 Want length of string including trailing blanks

Author  Topic 

Utpal
Posting Yak Master

179 Posts

Posted - 2002-08-01 : 07:29:48
Hi everybody,
Is there any function that returns the length of a string including trailing blanks ? Len() returns the length excluding trailing blanks. I could use Len(Replace("I-200 ", " ", ".")), but I would prefer a readymade function.


robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-08-01 : 07:47:52
DATALENGTH()

Go to Top of Page

Utpal
Posting Yak Master

179 Posts

Posted - 2002-08-01 : 07:57:12
Thanks !

Go to Top of Page
   

- Advertisement -