Is there any sql statement that enables me to view the field name and the data type that it accepts?
Of course this will vary with DBMS but the describe command might be what you are looking for. This works for Oracle (7, 8, 9 I believe all supprt this) and MySQL. Not sure about SQL Server.
PDP Data Solutions
It is very hard to make a good impression when your only crotch high.