Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Format decimal
Thank you for the answer BJCooper. That's what I meant Annie -
Format decimal
Hi, I have a field defined like 10 long with 2 decimals. When the data is 14.00. With the select statement, SQL + show the value is 14. I would like to display 14.00. Is there a way to set the format with some "SET" command. Thank you. Annie
