[V4MD1.1] replace with order by ?

[Ruslan Zasukhin]

On 1/28/05 1:03 PM, "Hans-Joerg Bibiko" <bibiko at eva.mpg.de> wrote:

> 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?

You need create BaseObject method with formula  REPLACE(fld1, 'AA', 'A')
And use it in the ORDER BY

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------