Increment a letter by 1

[Anthony Smith]

Lets say I have some SQL that is pulling this one value
SUBSTR(corp_id_nbr,1,1)

How can I make my sql increment the value by 1 when it is a character?

For example if SUBSTR(corp_id_nbr,1,1) = D, I want to be able to
increment to get the value E.

[adamin]

chr(ascii(SUBSTR(corp_id_nbr,1,1))+1)

[Antony Raj]

Anthony,

Do you want to increment any value in the arguments of SUBSTR() ?? or just increment the output value i,e if D then E

 

--
With Warm Regards
Antony Raj .V

"Knowledge is the only treasure that increases on sharing"

[Patricio Rodriguez]

did you try this way.

char => ascii => increment by 1 => char again.

Example

-------------

SELECT CHR(ASCII(SUBSTR('corporation', 1, 1)) + 1)
  FROM dual

Best wishes.

[Rob Wolfe]

Or, since someone re-opened the thread and I am feeling completely
over the top today .. try this

SELECT TRANSLATE(UPPER(SUBSTR(corp_id_nbr,1,1)),
'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
'BCDEFGHIJKLMNOPQRSTUVWXYZA')
FROM sometable;

IIRC this will even have the extra benefit of ignoring anything that
is not alpha and just plopping out the original value.

Like the rest of the folks here, I am assuming that you are just
trying to transform the output of your query and that you do
understand that there is an "update" statement if you actually want to
make a change to the values in the table.

[Patricio Rodriguez]

MUCH BETTER. THANKS