Returning A Count Of A Certain Field

I want to get a count of how many PosAnswer are associated with the QuesToAsk 'List your top 5 favorite places'

This is the syntax I am using to achieve this, and it works, but wasn't sure if there was a better way (changing the data structure is unfortunately not an option in this situation). Here is my table structure

Code:
Create Table Test
(
QuesToAsk varchar(1000),
PosAnswer varchar(1000)

[Code] ....

And this is the syntax I use to get the count I am after

Code:
DECLARE @VariableName varchar(25)
DECLARE @FormattedVariableName varchar(25)
DECLARE @FieldCount int
SET @VariableName =

[Code] ....