>>>>> "Keary" == Keary Suska <hierophant@xxxxxxxxxx> writes: Keary> If I surround the date with single quotes it should be Keary> fine, but I can't do that when I want to insert a null Keary> value. I know that I can do an "IF <use quotes> ELSE Keary> <don't use quotes>" in the SQL string, by I am entering Keary> many values and this would really get messy. I was hoping Keary> that there was a better solution. Thanks for any help. Why is this too difficult? You *are* doing some sort of input validation before you send the data to posgres aren't you? roland -- PGP Key ID: 66 BC 3B CD Roland B. Roberts, PhD RL Enterprises roland@xxxxxxxxxxx 76-15 113th Street, Apt 3B roland@xxxxxxxxxxxxx Forest Hills, NY 11375