I have a project that is taking input from another system. I have certain columns defined as 'Date'
Columns. On input I will get '000000' in this field which causes the insert to fail. I have read the docs on default and it is unclear to me if this will work. Does anyone have experience in solving this problem. The other alternative I thought of was to write a trigger to fix it ?? James M Doherty [EMAIL PROTECTED] Georgetown, TX 78626 "There is no luck without discipline" IRISH PROVERB ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend