CASE
WHEN ISNUMERIC(LEFT(RIGHT(AISLE, LEN(AISLE)-CHARINDEX('-', AISLE)),3)) = 1 THEN LEFT(RIGHT(AISLE, LEN(AISLE)-CHARINDEX('-', AISLE)),3)
WHEN ISNUMERIC(LEFT(RIGHT(AISLE, LEN(AISLE)-CHARINDEX('-', AISLE)),2)) = 1 THEN RIGHT('000'+CONVERT(VARCHAR,LEFT(RIGHT(AISLE, LEN(AISLE)-CHARINDEX('-', AISLE)),2)),3)
ELSE '000'
END AS AISLE_NUM,