Method Question

[Ivan Smahin]

Hello Ivan,

Monday, March 13, 2006, 7:13:50 PM, you wrote:

> Hello Michael,

> Monday, March 13, 2006, 6:48:32 PM, you 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'

Sorry - misprinting
SELECT REPLACE( REPLACE('JACK and JUE','J','BL'), 'A', 'O') 'Changes'

--
Changes
-------
BLOCK and BLUE



> --
> Best regards,
>  Ivan                            mailto:ivan_smahin ÎÁ valentina-db.com

> _______________________________________________
> Valentina mailing list
> Valentina ÎÁ lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina


-- 
Best regards,
 Ivan                            mailto:ivan_smahin ÎÁ valentina-db.com