I just tripped over a curious thing. It turned out that my d-b contained
the occasional column with accidental leading blanks. I altered the query
to:-
SELECT TRIM(LEADING ' ' FROM CUST_NAME) AS CN, COUNT(*) AS C FROM DB GROUP
BY CN ORDER BY CN
and ir barfed 00904 Invalid column name...
Graeme St. Clair [mailto:[EMAIL PROTECTED] wrote:
I just tripped over a curious thing. It turned out that my d-b contained
the occasional column with accidental leading blanks. I altered the query
to:-
SELECT TRIM(LEADING ' ' FROM CUST_NAME) AS CN, COUNT(*) AS C FROM DB
GROUP
BY CN
On 03/10/2005 01:52 PM, Graeme St. Clair said:
I just tripped over a curious thing. It turned out that my d-b contained
the occasional column with accidental leading blanks. I altered the query
to:-
SELECT TRIM(LEADING ' ' FROM CUST_NAME) AS CN, COUNT(*) AS C FROM DB GROUP
BY CN ORDER BY CN