By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select concat(convert(char(15), firstname), convert(char(15), lastname)),
len(concat(convert(char(15), firstname), convert(char(15), lastname))),
datalength(concat(convert(char(15), firstname), convert(char(15), lastname)))
from (values ('Michael', 'Jordan'), ('Lebron', 'James')) v(firstname, lastname)
| (No column name) | (No column name) | (No column name) |
|---|---|---|
| Michael Jordan | 21 | 30 |
| Lebron James | 20 | 30 |