Not identifying the NULL Values

Jabeen_Shukoor31Jabeen_Shukoor31 Posts: 2 New member
in SQL Data Generator
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
Tagged:
· Share on Twitter

Answers

  • Dan_JDan_J Posts: 459 Silver 2

    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?
    · Share on Twitter
Sign In or Register to comment.