[RESOLVED] Brain cramp kicked in - Number formating

[Frederick]

I need to remove all trailing zeros without using an interger field in the DB.
Example: 4.50000

I am inserting into a varchar field and this field preserves the original number. I need to strip these trailing zeros before insert or update without using number_format(), floor(), ceil() or round().

Thanx in advance.

[Shrike]

Cast the number to a float.

[Frederick]

Thanx, you lead me in the right direction, I used floatval() to do the trick.

It works for:
4.50000 = 4.5
4.00000 = 4