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 SkipVought 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
Apr 2, 2003
2
0
0
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
extract rows with characters in char field
Replies
6
Views
102
gdg1976
gdg1976
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
46
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
123
ANGELDANY
ANGELDANY
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
95
mikrom
mikrom
MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
73
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top