I'm pulling some values from sql into a textbox in my aspx page.
However when it fills the text box it looks like this: 99.0000
The datatype in sql is a money
How can I trim or clip the 2 extra zeros off?
THANKS!
Printable View
I'm pulling some values from sql into a textbox in my aspx page.
However when it fills the text box it looks like this: 99.0000
The datatype in sql is a money
How can I trim or clip the 2 extra zeros off?
THANKS!
You can use the Round() or Format() function.