SQL Question

[PeterL]

I wrote an SQL statement which selects records for export to a flat file. I need to begin the flat file with a comma. This flat file is comma delimited. How can I add a comma to the beginning of the SQL statement so that the file appears correct. Here is a sample of the SQL statement:

"SELECT ToCounter.LeadingComma,ToCounter.[Corporate Name],ToCounter.[Acct Address],ToCounter.[Acct City],ToCounter.[Acct State],ToCounter.[Acct Zip Code],ToCounter.UnitSerialNo,ToCounter.CoinValue,ToCounter.Commission,ToCounter.WriteDate,ToCounter.TechName FROM ToCounter

 

[PHV]

Have you tried this ?
SELECT Null,...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PeterL]

I don't understand. How does "Select Null," equate to a "," in my export statement.

 

[PHV]

Because I guess you'll export the query to a csv and if the first field is null then the first character will be the delimiter.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PeterL]

You are correct. This worked like a charm. Thanks