I have a table for Seller. If seller type is 'organization', I want the MidName of Seller to be blank (NULL). Is it possible to create a trigger that does so after insert?
Column names in table:
- Type(fixed value - either Org or Ind)
Type is "Org" then
MidName must be updated to blank (even if some value is entered during Insert)