How to show decimal poin in a result set?

Hi,

I have a field with dataqtype INT. I need to avg this field value and show in decimal with two points, which convert function do I use?

Thanks in advance!

Should change to decimal data type.

Use Cast or Convert to pretend that it's a differnet datatype.

Select Avg(Cast(FieldName as decimal(9, 2)))

Thanks, that worked.