• Bob Cullen-434885 (11/15/2013)


    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??

    I think it's that the LEFT function definition itself is not guaranteed to return a not null value, rather than being evaluated based on the particular column/usage.