>There is also ICASE function - I also think perhaps FixSQL can not handle all complex cases.
>

Indeed, the current FixSql() method only handles the specifie cases that you can see in the code and it has been crafted to specifically deal with the cases that I have encountered in my app so far. I think it what I've written will handle about 90% of the Select statements structures I use in my apps.


I'm not suggesting it will be very useful to anyone who has more complex Selects, but it is a good starting point for some users.

.