/heLen wrote:

> As a reality test (and risking having to kill the server) do you want to
> try this:
> select LAND,
> CAST(' ' AS CHAR) AS blank1,
> count(*),
> CAST(' ' AS CHAR) AS blank2
> from TITLER
> group by LAND, 2, 4
> order by 3 desc

It works fine!


Also, the following works, and delivers the space and the CR/LF:
select LAND,
CAST(' ' AS CHAR) AS blank1,
count(*),
'
'
from TITLER
group by LAND, 2, 4
order by 3 desc

Is 1 unnamed field ok, but "2 or more" is not allowed?


Thanks!

--
Aage J.