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

[Cyberskull]

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