What are the challenges you face when working across database platforms? Take the survey

Not identifying the NULL Values

I am trying to put the value '999' to the column num_of_units for all the NULL values in ordered_date column. but it is not working. Please help


  • Options

    Thanks for reaching out to us regarding this.

    Please correct me if I am missing something here, but from the screenshot you have provided (thank you for this) I can see that the 'num_of_units' column has a data type of varchar(1), this needs to be set to vachar(3) at least in order to be able to hold the value '999'.

    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.