Excel → T-SQL › MID

Excel MID to SUBSTRING

SQL Server does not have MID. It has SUBSTRING. Start at 1, not 0.

SUBSTRING(order_ref, 4, 2)

CHARINDEX finds the start when the position is not fixed.

Canonical translation

SUBSTRING(order_ref, 4, 2)

Then write it on a ticket

Monday is free. A colleague asks, you type, we mark it.

Clock in free
More Excel → SQL: VLOOKUPXLOOKUPIFIFERRORIFNAIFSCOUNTIFCOUNTIFS