Hi Kasper,yes, but it it would be complicated. I think you need to convert the number to an integer, subtract the integer from the original number, compare the result of that to 0.5 to decide what value to add to the integer to get your 'rounded to nearest 0.5' value that I think you're aiming for. SQL is really meant for querying databases, but it can produce 'calculated fields', so it could do what you want. It might be simpler with PHP.Plantigrade