problem with concat() in query

[Chris Sheffield]

Shouldn't this query work in Valentina 1.x:

SELECT CONCAT(LastName, ', ', FirstName), RecID FROM Teachers WHERE  
SETeacher=0 AND Type=0 ORDER BY LastName


I'm getting error "603 field not found" when trying to run it.  I've  
double-checked all field names and all are correct.  Is there  
something I'm not doing correctly?

I'm using Revolution, btw.

Thanks,
Chris

------------------------------------------
Chris Sheffield
Read Naturally
The Fluency Company
http://www.readnaturally.com
------------------------------------------