Please see this https://msdn.microsoft.com/en-us/library/ms174361.aspx .

The return type still has a max size of 8000 bytes.

Please note that the behavior of adding something to NULL depends on the option 'CONCAT NULL YEILDS NULL'. Please see the below msdn link for further details.

http://msdn.microsoft.com/en-us/library/ms176056.aspx

This...

Thanks. I switched to information schema.

I looked at msdn documentation and i know it corresponds to physical storage type. I want to know what exactly that type maps to.

Thanks