CREATETABLE #Locations
(Name1 VARCHAR(100))
INSERTINTO #Locations values('Scott,M,36')
INSERTINTO #Locations values('Eric,M, 24')

I need Output three columns like

Name Group Age
Scott M 36
Eric M 24

Thanks in advance

SELECT REPLACE(Name1 , ',', ' ')

__________________
Always,
Hovik Melkomian.

Didn't you ask nearly identically this same question in another post and/or another forum????

If you didn't then your clone did.

If you WANT three fields, then CREATE three fields. The DB can't magically guess that you want your single value to suddenly become three. Especially when you created the table to only have one field.

Yes! You did!

Why didn't you READ the answer I gave you yesterday????

SQL Server 2008 Query (comma separated)

Another Method is using MS Access:

• Load .txt file into MS Access;
• Folloow the import Wizard, which will show you yur imported file after you respond to how the file is delimited. In your case, you would select, "comma delimited";
• The file is then displayed. You will have the option to adjust the columns and name them (columns). Also the Wizard will ask if you wanted to add the primary key;
• Save the file in a table;
• The End;

Next is to export your table using the MS XL format;
Give the output file a name with the .xls extention;
File is created;
Locate file .xls and upload file into your SQL database;

Just another way of getting what you need.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.