<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi,<br>I would like to force the use of ANSI syntax ("expr direction NULLS LAST") in the ORDER BY of the SQL generated by Mondrian because my database does not support the default ORDER BY syntax (with a CASE expression in it). <br>I see that there is actually an alternative implementation "generateOrderByNullsAnsi" for the generation of the ORDER BY in the JdbcDialectImpl class that produces the desired output. <br>Is there an alternative to writing an implementation of the Dialect interface and rebuilding the source? <br><br>Cheers,<br><br>J. Barrasa<br> </div></body>
</html>