kevin.l.williams (8/23/2010)
Interesting that this does not work the same way.select datalength(convert(varchar, getdate(), 101))
See http://msdn.microsoft.com/en-us/library/aa258242(v=SQL.80).aspx.
When n is not specified with the CAST function, the default length is 30.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP