Replace first character in a string using an expression 1

[kernal]

How can I replace the first character in a string using an expression? Example:

00000

Results wanted (wanting the first character to be an X):

X0000

Help is appreciated.

 

[SantaMufasa]

select 'X'||substr('00000',2) result from dual;

RESUL
-----
X0000

Let us know if this resolves your need.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[kernal]

Worked wonderfully. Thanks Dave.