https://stackoverflow.com/questions/1014284/regex-to-match-2-digits-optional-decimal-two-digits https://stackoverflow.com/questions/43038769/regex-for-24-hour-time ^\d{0,3}\.?\d{1,2}$ UPDATE Customer_Orders_Revision set January_Order_Qty=@January_Order_Qty,February_Order_Qty=@February_Order_Qty, March_Order_Qty=@March_Order_Qty ,April_Order_Qty=@April_Order_Qty,May_Order_Qty=@May_Order_Qty, June_Order_Qty=@June_Order_Qty,July_Order_Qty=@July_Order_Qty,August_Order_Qty=@August_Order_Qty, September_Order_Qty=@September_Order_Qty,October_Order_Qty=@October_Order_Qty, November_Order_Qty=@November_Order_Qty,December_Order_Qty=@December_Order_Qty, January_PO_Number=@January_PO_Number, February_PO_Number=@February_PO_Number,March_PO_Number=@March_PO_Number,April_PO_Number=@April_PO_Number,May_PO_Number=@May_PO_Number, June_PO_Number=@June_PO_Number,July_PO_Number=@July_PO_Number,August_PO_Number=@August_PO_Number,September_PO_Number=@September_PO_Number, October_PO_Number=@October_PO_Number,November_PO_Number=@November_PO_Number,December_PO_Number=@December_PO_Number, January_PO_Date=@January_PO_Date,February_PO_Date=@February_PO_Date,March_PO_Date=@March_PO_Date,April_PO_Date=@April_PO_Date,May_PO_Date=@May_PO_Date,June_PO_Date=@June_PO_Date, July_PO_Date=@July_PO_Date, August_PO_Date=@August_PO_Date,September_PO_Date=@September_PO_Date, October_PO_Date=@October_PO_Date,November_PO_Date=@November_PO_Date,December_PO_Date=@December_PO_Date where Account_ID=@Account_ID, Customer_ID=@Customer_ID, Product_ID=@Product_ID, Year=@Year, Revision_Number=@Revision_Number