[2005] Checking SQL 2000 Table's Field's Data Type Using Code

Is there any way either by SQL code or by some other means to check the data type of a field?

Thanks for the help.

Ado

Via code - using SQLDMO.
Via SQL using the syscolumns table

-tg

SQL = "SELECT systypes.name FROM sysobjects,syscolumns,systypes WHERE sysobjects.name= '" & strTable & "' AND syscolumns.id=sysobjects.id AND syscolumns.name='" &_
strField & "' AND systypes.xtype=syscolumns.xtype"

Thanks for the reply, figured it out after i started thinking about the system tables.

Thanks for the help.

Ado