Method Question

[Michael Bedar]

Thanks guys, I'm not sure If it's the most elegant way to get this  
functionality, but its working, which goes a long way:)


On Mar 13, 2006, at 12:19 PM, Ruslan Zasukhin wrote:

> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina