XMLToaster

The fix works fine.
But... have just tried a select using the SQL-Server "cast" statement:

select 'rtsk/'+cast(r.empid as varchar) as taskCode
into xml:{result.tasklist.taskCode}

Unfortunately it bombs with SEVERE: Exception parsing the xmlselect
java.lang.NullPointerException
at com.inverse2.parser.SQLSelect.makeSQL(XMLSelect.java:3254)
at
com.inverse2.parser.XMLSelect.SelectStatement(XMLSelect.java:328)


Can you add "CAST(SQLexpression AS SQLtype)" to the list for the next
release?
Re-opening the SQL-Server syntax bug rather than creating a new one, as a
few more of these are likely to come out the woodwork.

Parser now supports the "top 999" syntax used by SQLServer. It does not
support "stop 99 PERCENT".
Parser now supports "like left(...)" syntax.

When I said "This is valid mysql syntax", hopefully you did not take it
literally.
Of course I meant it as a metaphore for sql-server.

Also number 2) may be because of the bug where the LEFT function is not
recognised because the parser is getting confused with the LEFT keyword
from "LEFT JOIN"...