search for: settlementst

This is more of a design issue I''m wrestling with, and was wondering what other people are doing. I have a products table with status values of In Stock, Out of Stork or Discontinued. This is unlikely to change any time soon. Approach A, is to have thses actual values in the status column, at least the meaning is very apparent, yet querying for products with a specific status could