Parsing

mwviola98 · July 19th, 2005, 03:10 PM

In the select statement, how do I code a list separated by commas in a single field to show as a single descending list?

example: field name: colors

values show as: red, blue, orange, green, and white

But in my results they must show as:

red
blue
orange
green
white

Any ideas?

happygv · July 19th, 2005, 07:06 PM

Where do you see the result? Is this related to MS SQL server/MS Access? Are you talking about SQL query analyser? Is that you wanted to do something from the frontend to get that kind of output?

No mention about that...

_________________________
- Vijay G
Strive for Perfection

mwviola98 · July 20th, 2005, 12:17 PM

Yes, I should clarify....

This will be SQL query analyser to export into a simple .xls spreadsheet.

happygv · July 20th, 2005, 02:11 PM

If you are looking at sql query analyser, then switch to grid mode(press CTRL + D). Then you should see the result in grid as you wanted.

Assuming your Select statement would look like

Code:

SELECT colors from TABLENAME;

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

mwviola98 · July 21st, 2005, 10:35 AM

Thanks, Vijay.