Update portion of a string column

[Yves Glodt]

Hi,

I have a column that has a string field, and I only wanna update the 3rd
character in the string. e.g. change 'StRing' to 'String'. Is this
possible with raw sql?
I can do it with a simple php script, however the raw sql solution would
be prefered.

regards,
Yves Glodt



----------------------------------------------------------------
ELECTRO SECURITY
Yves Glodt yves.glodt at electrosecurity.lu
Support Informatique
73, rue de Strasbourg Tél: ++352 406 406-1
L-2561 Luxembourg Fax: ++352 406 407
Web: [url]http://www.electrosecurity.lu[/url]
----------------------------------------------------------------

[PM \(pm3iinc-nospam\)]

Anything similar to
values(
concat ( (left('abcdef', 2)), (concat( ('z'),
(right('abcdef', length('abcdef')-3)) ) ) )
)

PM

[Lennart Jonsson]

Yves Glodt <yves.glodt@SPAMTRAPelectrosecurity.lu> wrote in message news:<3f616642$1_1@news.vo.lu>...

> Hi,
>
> I have a column that has a string field, and I only wanna update the 3rd
> character in the string. e.g. change 'StRing' to 'String'. Is this
> possible with raw sql?
> I can do it with a simple php script, however the raw sql solution would
> be prefered.
>
> regards,
> Yves Glodt
>

how about

update t set c = substr(c,1,2) || 'r' || substr(c,4)


/Lennart

>
>
> ----------------------------------------------------------------
> ELECTRO SECURITY
> Yves Glodt yves.glodt at electrosecurity.lu
> Support Informatique
> 73, rue de Strasbourg Tél: ++352 406 406-1
> L-2561 Luxembourg Fax: ++352 406 407
> Web: [url]http://www.electrosecurity.lu[/url]
> ----------------------------------------------------------------