MS SQL Server New Users - Comma Separator

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Comma Separator

Ray

2005-11-16, 8:24 pm

I have a table that includes company names with commas and some without
commas. When I pull a report to save in a csv format it is putting part of
the name in one column and the rest of the name in another column. I thought
about concatanate but the length of the company names is not the same, for
instace but it is the same data_type (varchar):

Table Company
Select company_name from company

Results:
Col 1 Col 2
John Brown Inc
John Smith Inc
Larry Brown & Smith
John, Bill, and Susey Jones

Is there a way to filter out the comma (,)?

Thanks.
--
Ray

Sponsored Links