Excel → T-SQL › LEN
Excel LEN to SQL LEN
LEN('abc ') is 3 in SQL Server. If you need the spaces, DATALENGTH (and divide by 2 for nvarchar).
LEN(email)
-- trailing spaces
DATALENGTH(email) / 2 -- nvarcharBlank vs NULL: LEN(NULL) is NULL. LEN('') is 0.
Canonical translation
LEN(email)
-- trailing spaces
DATALENGTH(email) / 2 -- nvarcharThen write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free