SELECT CompanyName
, len(CompanyName) as 'length'
, datalength(CompanyName) as 'RealLength'
FROM TempfinanceCompanyList
WHERE right(Companyname,1) = ' '
ORDER by CompanyName
You cannot count on LEN function to count trailing spaces, at least not in SQL 2012.
ORDER by CompanyName
You cannot count on LEN function to count trailing spaces, at least not in SQL 2012.
No comments:
Post a Comment