Greetings - This weekend I needed to write a HQL query which relied on SQL functions to search in some text. I found the 'substring' and 'locate' HQL functions and then found that SQL CE's dialect didn't work with these because these functions are not registered in that dialect. In fact, _no_ functions are registered in that dialect.
I created a custom dialect and added all the SQL Server functions which CE supports and after doing this, the HQL query worked very well. Does anyone know if this is just missing functionality, or was there a deliberate reason to leave out SQL functions from CE? If it's missing, I could just add a JIRA ticket and submit a patch... -rory
