Excel → T-SQL › LEFT
Excel LEFT to SQL LEFT
The first four of a UK postcode is LEFT(postcode, 4) after you TRIM.
LEFT(LTRIM(RTRIM(postcode)), 4)Do not LEFT a datetime to get a year. Use YEAR() or a range. LEFT on a date is a format accident.
Canonical translation
LEFT(LTRIM(RTRIM(postcode)), 4)Then write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free