Method Question

[Ivan Smahin]

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'

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



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