I am trying to get a column count of the number of columns in a table called Soloists; the database is myCDDB.

I understand that the information is to be found in INFORMATION_SCHEMA.COLUMNS and I think that the following select statement should be used:

Select Count(*) From INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME='Soloists' and TABLE_SCHEMA = 'myCDDB'"

but how do I get a count value from this statement.