Checking data type

How can I check data type of a column?
Thanks.
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='yourtable' AND COLUMN_NAME='yourcolumn'
http://www.aspfaq.com/
(Reverse address to reply.)
"Vik" <viktorum@.==hotmail.com==> wrote in message
news:OHx7750nEHA.3876@.TK2MSFTNGP15.phx.gbl...
> How can I check data type of a column?
> Thanks.
>
|||Sp_help? Select against INFORMATION_SCHEMA.COLUMNS?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Vik" <viktorum@.==hotmail.com==> wrote in message news:OHx7750nEHA.3876@.TK2MSFTNGP15.phx.gbl...
> How can I check data type of a column?
> Thanks.
>