Thanks for the reply. I have another question:

If I use the following:

EXEC sp_columns @table_name = 'X', @column_name = 'YY'

How do I check if the result set returned is empty...