Thanks for the reply Guyz. you are the best 🙂

Awesome. This was exactly what i was looking for. Thanks you!!!

Thats it! really appreicate your help on this.

Thanks for responding.

In the above example i want a result like this.

Id AvgPrice

1 1111.1111

2 20

If there is a record with a price of...

Thanks for the reply.

Iam trying to cast as decimal because i need the decimal precision for the data that will be used later in my logic.

select CAST('1.d20' as decimal(10,3))...