>Erik
>
>We use code for one simple reason: the ability to use things like
>
>{ fn UCASE(myfield) }
>
>in our views. That works against everything. But most automated generators convert that- eg against SQL Server the above gets converted to
>
>UPPER(myfield)
>
>which usually still works against Oracle and others like Cache, but isn't approved odbc.
>

EView has absolutely no problem with this stuff. It doesn't touch your SQL at all.