07-31-2023, 02:42 AM
Try this
```sql
SELECT CONVERT(DECIMAL(10,2),YOURCOLUMN)
```
such as
```sql
SELECT CONVERT(DECIMAL(10,2),2.999999)
```
will result in output `3.00`
![enter image description here][1]
[1]:
```sql
SELECT CONVERT(DECIMAL(10,2),YOURCOLUMN)
```
such as
```sql
SELECT CONVERT(DECIMAL(10,2),2.999999)
```
will result in output `3.00`
![enter image description here][1]
[1]: