compudude86
IS-IT--Management
- Jun 1, 2006
- 46
ok, i have a few different fields, in decimal, how would i put the $ sign in front of the numbers, what would i put into query?
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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
adding dollar sign to fields
- Thread starter compudude86
- Start date
- Status
TonyGroves
Programmer
You would not store a $ in the table; you would add it in your select query:
[tt]
SELECT CONCAT('$',fld1) fld1, CONCAT('$',fld2) fld2
FROM tblname
[/tt]
[tt]
SELECT CONCAT('$',fld1) fld1, CONCAT('$',fld2) fld2
FROM tblname
[/tt]
- Status