Using Powershell is simple, the syntax is sqlcmd -Lc | Out-File c:\serverlist.txt

the data type for mycolumn is varchar and I am expecting some numeric values as I have setup the mycolumn to output numeric values.

I can get the output desired from...