|
View previous topic :: View next topic
|
| Author |
Message |
gvel19
New User
Joined: 20 Jul 2008
Posts: 19
Location: Schenactady, US
|
|
|
|
I need a SQL Query that is used to change a single character of a column value in a db2 table.
Eg., I have a name "JAYANTHI". I need a SQL query to change the first char "J" alone to "Z". How can I achieve this ?. This is an interview question. |
|
| Back to top |
|
 |
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| You can not update part of a column so you would have to use a literal, substring and concatenation to accomplish that. |
|
| Back to top |
|
|
|
|
