I have a sql query = Select FirstName, '' as MiddleName, '' as Sirname from tnlNames
I dont want to ouput the Middlename, I use the bcp to create a csv from the above query.
The file creates no problem but when I open the file with note pad I get an extra space in middle name.
but im after
I cant actually see the ASCII value of the space, Im still looking for some software to assist me in that one.
The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.