Report Currency Formatting

[clinicoffice_user]

Hi,
 
I have CO v 5 with Synergy Physio and Rehab Ltd in Surrey.
 
Could you tell me what the SQL code is to display a column of data in a report in Currency format – i.e. £x,xxx.xx?  This would be for a custom column I have created from two other numeric data fields such as salecost or purchasecost.  I have tried cast as numeric but that does not give the correct result.
 
Regards,
 
Godfrey
Director
The Running School Woking

[Author]

Posts