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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QUESTION in CAST

Status
Not open for further replies.
prasadraon

prasadraon

Programmer
Joined
Apr 2, 2003
Messages
2
Location
US
Hi all
i am trying to cast a value as double or decimal in my select and it returns me the value in a scientific 0.500000000000 but i dont want all that zeros i want simply 0.50

any suggestions
thanks in advance
logic4fun
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question Question
extract rows with characters in char field
Replies
6
Views
948
gdg1976
gdg1976
gdg1976
  • Locked
  • Question Question
hi all, input TAB1 COL1
Replies
0
Views
430
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question Question
WEEK ISO with Dates in string format YYYYMMDD
Replies
4
Views
1K
ANGELDANY
ANGELDANY
gdg1976
  • Locked
  • Question Question
db2 sql extract double rows (different in case sensitive)
Replies
6
Views
750
mikrom
mikrom
MohanV
  • Locked
  • Question Question
Using table functions in Query
Replies
5
Views
652
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top