Hi, I'm trying to run the following query in SQL Server 2000:
Select DISTINCT (lname + ', ' + title + ' ' + fname) AS Name, pho As Phone, (unit + ', ' + jobtitle) As UnitTitle,
eadd As Email, (room + ', '+ build) AS Location
From tbl_teldir
Order by Name ASC;
It looks right when I run the query, but when I save it to a CSV (comma seperated) the columns are off. The problem is with the jobtitle. Within the jobtitle there may or may not be a comma, for example:
Assistant Director, Greeklife
So when I string the unit and jobtitle together, I get this:
Student Activities & Organizations, Assistant Director, Greeklife
Because only a few jobtitles have a comma, when I save it as CSV it seperates the Jobtitles with the commas.......which throws them into the column with the email address. Is there anyway to keep it from seperating the jobtitles with a comma in them?
Start Free Trial
