Hi all!
I have found that the CHRTRAN() function breaks SELECT – SQL command with GROUP BY clause.

Example:

CREATE CURSOR PostCode (cPostCode C(15))
INSERT INTO PostCode (cPostCode) VALUES ('M 3 J 1 M 5')
INSERT INTO PostCode (cPostCode) VALUES ('M3J1M5')

* No problem !
SELECT DISTINCT CHRTRAN(cPostCode,' ','') ;
FROM PostCode

* SQL: internal error ???
SELECT CHRTRAN(cPostCode,' ','') ;
FROM PostCode ;
GROUP BY 1

What is wrong with second SELECT – SQL command?

Thanks.