Excel → T-SQL › UPPER

Excel UPPER to SQL UPPER

Comparing LOWER(a) = LOWER(b) is a scan. Better: store consistently, or a persisted computed column.

UPPER(sku)

A leading UPPER() in a WHERE is not SARGable. Match the stored case or use a computed column.

Canonical translation

UPPER(sku)

Then write it on a ticket

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

Clock in free