• the function LEFT can return NULL values therefore the computed column is created as NULL

    Just how can LEFT return a NULL when operating on a CHAR(8) NOT NULL value??