8 | * 7 | * 6 | * 5 | * 4 | * * 3 |* * * * * * 2 |* * * * *** ** * * 1 |* * *** ****** **** * * +---------------------------
I would like to be able to round a number to n significant figures in SQL. So: 123.456 rounded to 2sf would give 120