convert a varchar to a number in a query

[sjjustina]

Hopefully this is an easy one. I'm trying to get an average of a length field but the field is varchar(8).

This is my query:
SELECT AVG(CONVERT(varchar(8), pcslength, 0)) AS AvgLength
FROM tag_detail
GROUP BY tagnum

The convert doesn't seem to be working. Is there another way to do this?

 

[monksnake]

How would you know they are the people that helped you?

<.

 

[AlexCuse]

I don't get out much, but thanks for the offer. I'm glad you got it working, and best of luck with your new job! Sounds like you have your work cut out for you

Ignorance of certain subjects is a great part of wisdom

 

[AlexCuse]

George - That function is sweet! (I missed it because we cross posted) I never thought to use vbScript like that.

Methinks it is worth a star :-D

Ignorance of certain subjects is a great part of wisdom