ImmortalKenny

Basically there is a column called "Retail" and the numbers are formatted like "39.95." How do I add a dollar sign in front of the data to make it like "$39.95" and apply it to the whole column?

__________________

cytrik

normally you wouldn't store symbols in tables, it is preferable you do this via PHP output, if it's for a website, do you absolutely need it in tables?
the other problem with this is, PHP or other interpreters would take the $ for string or whatever it stands for in the language pulling the info and parsing it

DuckieHo

Store it as float and format it when you display it.

__________________
To answer most of your questions: (1) a fridge cannot cool a PC (2) 64-bit OS for over 3.4GB (3) If a PCIe card fits, it should work (4) Resolution, not screen size (5) If you have a question, it is not news (6) Report, not respond to Spam (7) Single-Rail/Non-Modular PSUs are not always better than Multi-Rail/Modular

ImmortalKenny

It's for homework, but I'm going to school tomorrow to ask the professor.

__________________

chemicalfan

If you want to store it in the table, you've have to change the type of the column to from number to varchar - I wouldn't do this if I were you, or you could run into all sorts of trouble later when you attempt to use the data as a number.

When you run your SELECT statement later to get the detail out, you can add the symbol in then. Or, you could create a view with the symbol in - this is probably the best plan thinking about it, because you can convert the column to varchar in the view and it won't make any different to the table

__________________

Intel Processor Finder - essential knowledge for OC'ers
OCCT - essential tool for OC'ers

Microsis

As everyone states, it's good practice to store data as simply as possible then format it on output.

__________________
FOR SALE: | Modded CM690 | OCZ 700W PSU | WD 36GB Raptor | Tuniq Tower 120 *Lapped*

The 750i FTW Overclock Thread
The 55nm GTX 260 216 Overclock Thread

BC2 > MW2