only calculate before the comma
Posted: Tue Jul 01, 2008 12:16 pm
Hello people,
I am having problems with the comma sign in the amount field. I have a figure in my amount field that looks like this;
7500004
when i try to transfer a sum that looks like 750,0004, it will only calculate all the figures before the comma.
I wanna know if i have an error in my database or what.
my table looks like this
amount varchar(255);
do i need to change the column type to something like FLOAT, DECIMAL or what.
Thanks in advance
I am having problems with the comma sign in the amount field. I have a figure in my amount field that looks like this;
7500004
when i try to transfer a sum that looks like 750,0004, it will only calculate all the figures before the comma.
I wanna know if i have an error in my database or what.
my table looks like this
amount varchar(255);
do i need to change the column type to something like FLOAT, DECIMAL or what.
Thanks in advance