Hello,

The following script will Round 12999 to 13000:-

Select Round(12999, -1)

This works for the example that you provided, but what is the underlying rounding algorithm that you need?

Regards,

John Marsh