Hello,
I'm currently working on a school assignment where I need to add data to a column only if a certain condition is met.
In this scenario, I need to check from a list of student emails, which ones end with "@blabla.com".
Can anyone explain to me how I'd go about setting up such an ALTER?
To this point I've gotten to:
ALTER TABLE [table_name]
ADD(CONSTRAINT ch_[column_name] CHECK (
([column_name] = ??????)));
All help will be extremely appreciated!!!