have a look to the dialect you are using and let me know if the LEFT
function is there or not.Thanks.

2009/8/13 nerode <[email protected]>

>
> Other than the fact tha I can find no documentation on this (any links
> appreciated), I've found a change from the previous parser:  a
> statement that is designed to be executed against MSSqlServer (2000 or
> 2005 dialect) used to accept the function LEFT(value, count).  This
> now throws a NoViableAltException.  Replacing it with SUBSTRING(value,
> 1, count) works.
>
> Is this intended?  Can someone identify other functions that once
> worked but will now fail (at runtime)?
>
>
> >
>


-- 
Fabio Maulo

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to