String manipulation

[TheDigglerUK]

Hi, this is going to be real easy i think but i just cant do it.

I have a query that sends me back an answer like '3.2'

I want to either round it off to the nearest number, i.e 3 and/or add a zero to the end if it has a '.' in it and or get rid of the '.'

Any help would be great.

Thanks

Jules

[drew010]

[man]number_format[/man] or [man]round[/man] depending on which way you want to go.