SQL Query: Tab delimited and dollar amounts

Discussion created by Diver on Sep 22, 2013
Latest reply on Sep 23, 2013 by greglane

Playing with basic SQL in FileMaker, I have it return the data I want but not in the format I want.


The first two lines in my script's "Set field" are:


ExecuteSQL ("SELECT InvoiceNum, OrderDate, TotalAmount

FROM TestTable


This returns the proper data but formatted like:






I am not sure how to have it return a tab delimited format and use proper formatting for dollar amounts with 2 decimal places, as shown below:


12345 2013-09-22 400.10

12346 2013-09-22 299.00

12347 2013-09-22 199.23


I have experimented with || char(9) and ", " , " " and have had no success with the delimination. I have no clue on how to do the 2 decimal point accuracy.


I welcome any direction or examples.