Qoutes in "Output to" statement

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Thread Tools

Display Modes

polzovatel

Posts: n/a

Qoutes in "Output to" statement - 12-16-2003 , 05:40 AM

If I run the following statement:
---
select time1, time2 from table1 ;Output to c:\test.csv Quote '"' ALL;
---
and time1 is Null
it writes
---
, "12:00"
---
to a .csv file and I want it to be
---
"","12:00"
---
Any ideas how can I do it?

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off