How to show decimal poin in a result set?

[jannat]

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!

[rmiao]

Should change to decimal data type.

[Rawhide]

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

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

[jannat]

Thanks, that worked.