How can we help you today? How can we help you today?

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
Jabeen_Shukoor31
0

Comments

1 comment

Sort by
  • Dan_J
    Hi @Jabeen_Shukoor31

    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'.

    Dan_J
    0

Add comment

Please sign in to leave a comment.