If you are using odbtp as a driver for the mssql ext, and want mssql_field_type() to return the actual type name, then call odbtp_set_attr( ODB_ATTR_FULLCOLINFO, 1 ); before you run any queries. -- bob On Thu, 3 Jun 2004, Frank M. Kromann wrote: > mssql_field_type() is the function for that. > > - Frank > > > Robert, > > > > Do you have an example of pulling the Column types from an MS Sql query? > For example: select top 1 * from mytablename. > > > > loop thru the fields in the recordset and print out their data types? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php