Method Question

[Ruslan Zasukhin]

On 3/13/06 7:13 PM, "Ivan Smahin" <ivan_smahin at valentina-db.com> wrote:

>> Ok, so if I understand it, If I want to filter out the "+" char, I
>> could make a vFiled with a method like:
> 
>> "REPLACE(origional_field, '+', '')"
> 
>> If that's correct, how would you string 2 of these together?
> 
>> "REPLACE(REPLACE(origional_field, '^', ''), '+', '')"  ???
> 
>> Thanks for answering the newb questions.
> 
> Yes, you could play with VStudio trying such a query:
> 
> SELECT REPLACE( REPLACE('JACK and JUE','J','BL'), 'A', '1') 'Changes'

Not very comfortable..

Nothing more suitable? I will look now.

May be there there is sense add new function as:

    filter( fld, "+-/." )   -- i.e. Remove each and any
                                character from set "+-/."

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]