prototyping out sqlstatement. adding append method to handle various .net types.
adding appends for various types [decimal, date, time, datetime, int, short, long]