Is it a good idea to use COLUMN AS (left([Another_Column],(4)) instead of LEFT in the select?
If the computed column isn't persisted or indexed, it's only a virtual column (expression), and it's not taking up any "space".