update data in a field

[Martin Hayer]

Hi,

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

\organization\name\surename\zip\city

I want to update the content from "\organization"
into "\neworganization" followed by "\name\surename\zip\city"

yours

marvin

[Hugo Kornelis]

On 18 May 2004 05:37:35 -0700, Martin Hayer wrote:

Hi,

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

\organization\name\surename\zip\city

I want to update the content from "\organization"
into "\neworganization" followed by "\name\surename\zip\city"

yours

marvin

Hi Marvin,

Try

select replace
('\organization\name\surename\zip\city','\organiza tion\','\neworganization\')

Best, Hugo
--

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