sql query

1. the output from a table is as follows:
col1
----
a
b
c
d
e
f

6 rows selected.
========================================
2. but i want to display the sql output as:
col1
----
a,b,c,d,e,f

1 rows selected.
===========================================
how do i do that. thanks

.

Relevant Pages

  • Re: Combo Box Display Value
    ... Bound column is col1. ... I want to display the values of col1 and col2 as selected. ... If the bound column is numeric, ...
    (microsoft.public.fox.vfp.forms)
  • comparing two values
    ... A or some other ones may be Col1: A and Col2: A. Values range from A to F. ... What I want to display is: if Col2 is less than Col1 display "Dropped", ... Jerry ...
    (microsoft.public.excel.worksheet.functions)
  • sort to top
    ... Depending on a column value, i want to display the rows. ... That is if the col1 has val1 i want it in the beginning rows of the ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: sql query
    ... but i want to display the sql output as: ... Rene Nyffenegger ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • Re: How to drop a default value for a column
    ... modify (col1 default drop) should work but it didn't ... Kalle ... Prev by Date: ...
    (comp.databases.oracle.misc)