[V4MD1.1] replace with order by ?

[Hans-Joerg Bibiko]

I have the following problem:

I tried this SQL statement

SELECT fld1 from tbl1 ORDER BY REPLACE(fld1, 'AA', 'A')

but I get a syntax error.

Is this kind of replacing not allowed in Valentina SQL or did I a mistake?

Many thanks

Hans