I am trying to figure out how to get an item code/product code to have a letter fixed to the start each time I create a new product.
For example, if the product code is A1234
the person cannot change the letter A
, but they can change the last 4 numbers.
PRODUCT_CODE
must have 5 characters (the first being A
and the rest numbers)
How can I create a constraint on the Product_code
column such that it must begin with A
and end in four numbers (if it is not in this format, and is it possible to do it with a where clause? Thanks