I�m building a few simple SQL Methods to learn my way around. (1) Does Gadfly support a �date� data type? I keep getting failures in attempts to create new tables with column type DATE, but same SQL succeeds when DATE is changed to VARCHAR This failed� CREATE TABLE pimtest ( First_Name VARCHAR, Last_Name VARCHAR, State VARCHAR, Home_Phone VARCHAR, First_Entered DATE, Last_Modified DATE) This succeeded� CREATE TABLE pimtest ( First_Name VARCHAR, Last_Name VARCHAR, State VARCHAR, Home_Phone VARCHAR, First_Entered VARCHAR, Last_Modified VARCHAR) (2) Also, adding field length to seemed to make table creation fail. Am I doing something wrong there? VARCHAR worked OK VARCHAR(12) failed Thanks! Dave === David Robson robson555@yahoo.com Computer Support Towson High School, MD, USA __________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com