thanks for the pointers so here's what we've got now based on your recommendations

/****** Object: Table [dbo].[WorkOrder] Script Date: 12/09/2012 16:21:34 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET...

Thank you so much for your response, I relized you answered exactly what I asked but what I asked was close to what I wanted but a little to different...