View previous topic :: View next topic |
Author |
Message |
GinoTheCop
Joined: 30 Dec 2005 Posts: 9
|
Posted: Fri Dec 30, 2005 4:46 am Post subject: Howto get data before and after comma? |
|
|
I have data in rs which i pull from my database. The data in one field is like this;
13,14.2 (first is a comma and second is a fullstop)
I need to make calculations with certain formulas with these data. But my problem is; i need to get the values before the comma and after the comma.
So it should be like this:
13 X 14.2 = 184.6
How can i extract the values before and after the comma?
Thanks for your help... _________________ Cuneyt Yetgin |
|
Back to top |
|
|
administrator Site Admin
Joined: 01 Oct 2004 Posts: 183
|
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|