Oracle SQL V8

2005-03-10 Thread Graeme St. Clair
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...

RE: Oracle SQL V8

2005-03-10 Thread Ronald J Kimball
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

Re: Oracle SQL V8

2005-03-10 Thread Michael A Chase tech
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