Excel → T-SQL › RIGHT
Excel RIGHT to SQL RIGHT
Same function. Watch trailing spaces — TRIM first.
RIGHT(LTRIM(RTRIM(phone)), 4)For “last 4 of an identifier that might be short”, LEN and a CASE beat a blind RIGHT.
Canonical translation
RIGHT(LTRIM(RTRIM(phone)), 4)Then write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free