| 5:27 pm on Dec 26, 2012 (gmt 0)|
If you want to sort the numbers, you'll need to use a numeric type (int, etc.). Use the Format() function to format the numbers with commas when displaying them.
| 5:33 pm on Dec 26, 2012 (gmt 0)|
THe numbers in question come from a third party source already formatted with thousandths as 1,200 etc. So its not a question really of inputting them as 1200 and displaying them with commas.
I just want to be able to input them as I receive them i.e 1,300 into database and then be able to sort them by asc/desc correctly which obviously storing them as varchar does not do.
| 5:38 pm on Dec 26, 2012 (gmt 0)|
And int etc does not insert them correctly, I guess Im just going to have to alter them before insertion so 1,200 becomes 1200.
| 6:04 pm on Dec 26, 2012 (gmt 0)|
You'll need to either:
A) Strip the commas when you import them as INT, or
B) Import them as VARCHAR then strip the commas and save into a different field (type INT).
|brotherhood of LAN|
| 6:10 pm on Dec 26, 2012 (gmt 0)|
|A) Strip the commas when you import them as INT, or |
I'd go for LifeinAsia's A) suggestion, as it's trivial to replace the commas while performing operations on a smaller and fixed length field has its advantages.
| 6:16 pm on Dec 26, 2012 (gmt 0)|
Yea thanks, just done that, works as I want now:
$variable = str_replace(',', '', $variable);