Using SQL sets the internal DB format of the field. What you are looking for is the display format of the field.
Now normally you can just edit the table and change the field format. However, based upon previous questions (and you should have stated here) you have a split DB so you cannot edit table fields.
To change the display format in a split DB, view the table. Right click the column heading you want to modify and select
Column format.... Then choose the format you wish to display - in your case
Currency. when completed make sure you save the changes - will be indicated on main .odb form. Will display in your format from that point on.