Thanks for everyone's replies, very helpful.

one more question, since there is no boolean type, and I need to create a
domain, is it better to have a char Y,N, or integer 1,0 to accomodate the
use of checkboxes and boolean flags used in my application?

are there advantages of one over the other method??
Thanks
Daniel