Currency Symbol added to Database Colum ?

[Johnny Dee]

Hi,

How do I put a currency symbol $ in front of the value in a Database collum
please ?

Thanks

John.

 

[Jon]

Hi,
you could add it in your query, eg
select '$' + MoneyField AS MoneyField
or use formatcurrency on your page
<%=formatcurrency(Recordset("MoneyField"))%>
normally using formatcurrency would be better as it also formats the number
to 2 decimal places, eg £10.20 not £10.2

Jon
Microsoft MVP - FP

 

[Johnny Dee]

Hi Jon,
I'm not sure where to put the line of code you said to put in the page?
Here is the colum of code. Can you advise me please where to place it in
the lines please? I want to format the RRP ex GST.
Thanks again.
John.
<td><!--webbot bot="DatabaseResultColumn" startspan

s-columnnames="ID,Primary Supplier,Supplier Product
Code,Brand,Category,Type,OEMPartNumber,Description,Availability,Last
Modified,Last Update,DBP ex GST,DBP inc GST,RRP ex GST,RRP inc GST,GST,Case
Qty,Desired GP %,For Use In,Information"

s-column="RRP ex GST" b-tableformat="TRUE" b-hasHTML="FALSE" clientside

local_preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;RRP ex GST&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"

preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;RRP ex
GST&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_r
s,"RRP ex GST")%><!--webbot

bot="DatabaseResultColumn" I-CheckSum="20001" endspan -->

</td>