• can anyone explain me why select len(@a) as 'declared' gives output as 1

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/