General information
Category:
Coding, syntax & commands
Title:
CHRTRAN() breaks SELECT – SQL command with GROUP BY clause
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only