Hi there,
Here’s the example how to round values to 9.99 at the end. For example if we have a price 45023.12 and we wanna change it to 45029.99, we should simple use this code:
|
SELECT CONCAT(LEFT(ROUND(YOUR_PRICE, 0), CHAR_LENGTH(ROUND(YOUR_PRICE, 0)) - 1), '9.99'); |
See ya!