Using Concat in ORDER BY

[Trevor DeVore]

Hi,

I'm converting some SQL I have running in MySQL over to Valentina 1.x.  
I have a query which orders records returned using the Concat function. 
  Here is a simplified query which shows the basic concept:

SELECT Title, Sequence FROM lesson ORDER BY Concat(Sequence, '.', Title)

I keep getting 604 syntax errors though.  Is this type of ordering 
possible in Valentina 1.x and if so what is the proper syntax?

Thanks,


-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com