Forum Stats

  • 3,838,112 Users
  • 2,262,333 Discussions


Avoid Empty Quoted Strings for NULL Varchar/Char data while exporting to csv

I'm using PUT_LINE_NCHAR to write data into csv's

here I can see that NULL strings are written in csv's as empty quoted string ("") for char and varchar columns and for int type columns I can see empty unquoted string in csv (blank/zero length)

Now, I want to avoid those empty quoted string for NULL data of char and varchar columns instead need unquoted empty string

how can I achieve???

Thanks in advance