Update a certain part of column

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Hi,

i want to update a certain part of column .

eg :

there is column NAME (char(20)) .
i want to change first letter of column NAME from 'a' to 'b' .

so i want to know can i use substring command with update .

Thanks in advance,
-Kapil .

Gurmeet · New User Joined: 22 Feb 2006 Posts: 46 Location: Pune

Kapil,

User this query,

UPDATE Table_name SET name = 'b' || SUBSTR(name,2)
WHERE name = 'abc';

~Gurmeet

krish_mrt · New User Joined: 15 Apr 2005 Posts: 12 Location: Chennai

Hi,
Try this update

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Thanks Buddy .
this seems to be perfect

-Kapil .

rexzone1 · Posted: Wed Nov 19, 2008 7:46 am

Hi,

I need to do the same operation(Update particular part of a column) on a numeric field.
Could you please suggest me a way if there is any (without using a program).

Thanks.

dick scherrer · Posted: Wed Nov 19, 2008 8:30 am

Hello,

Possibly, if what you need to do can be accomplished by some calculaton. . .

Otherwise, write the code. . .

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Well, it would be better if you can provide exact requirement details.

-Thanks,
-Kapil.

Vivek_Vasudevamurthy · Posted: Thu Nov 20, 2008 12:08 pm

Hi friends,

if i want change any letter in center or set of letters how it will work

For a example

"ABCDEF"

now i want to change "CDE" to "XYZ"

==============================
User this query,

UPDATE Table_name SET name = 'b' || SUBSTR(name,2)
WHERE name = 'abc';

in this query what 2 stands for

ashok_uddaraju · New User Joined: 21 Feb 2007 Posts: 72 Location: US

Let me put in some idea on how the substr command works.

when i say SET name = 'b' || SUBSTR(name,2)

then the the letter 'b' in the first position (i+1) which is 1+1 in this case will be considered.

If you want to change the first two characters it should be

'bc' || SUBSTR(name,3) ----- i+2

One thing i ma not clear is what can be done when we require a substring to slect from some where in the middle.

I assue there should be one more parameter in the SUBSTR command in that case.

Can some body suggest on this?

dick scherrer · Posted: Thu Nov 20, 2008 10:50 pm

Hello,

Something to keep in mind is that many/most data manipulation requirements will not be met by some simple sql query. . .