Convert scientific notation to text and saving in .csv file

Hi all,

How do I handle long number so when I convert my sql result set, I wont have the scientific notation in csv?

Thanks all

what are you using to produce the CSV? SSIS, C#, PoSH, Excel? The answer will depend on that.

Hello gbritton, I am using sql query. Thank you.

OK -- please post your query