Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

ALLBASE: GROUP BY CAST(..) ?

SOLVED
Go to solution
Werner Ittner
Occasional Advisor

ALLBASE: GROUP BY CAST(..) ?

Does anybody know if this syntax is allowed in ALLBASE :

SELECT ..
FROM ..
WHERE ..
GROUP BY CAST(Variable, INTEGER);

Thanks

Werner
1 REPLY
Sanjay Kumar Suri
Honored Contributor
Solution

Re: ALLBASE: GROUP BY CAST(..) ?

It is not allowed.

Cast is a Single-Row conversion function. It can't be used in GROUP BY clause.

Thanks.

A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.