update data in a field

[Martin Hayer]

Hi,

how can i update the data in a field like that:

\organization\n ame\surename\zi p\city

I want to update the content from "\organizat ion"
into "\neworganizati on" followed by "\name\surename \zip\city"

yours

marvin

[Hugo Kornelis]

Re: update data in a field

On 18 May 2004 05:37:35 -0700, Martin Hayer wrote:
[color=blue]
>Hi,
>
>how can i update the data in a field like that:
>
>\organization\ name\surename\z ip\city
>
>I want to update the content from "\organizat ion"
>into "\neworganizati on" followed by "\name\surename \zip\city"
>
>yours
>
>marvin[/color]

Hi Marvin,

Try

select replace
('\organization \name\surename\ zip\city','\org anization\','\n eworganization\ ')

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)