Page 1 of 1

Replace a char in value of colomn

Posted: Thu Aug 23, 2007 9:28 am
by srinivenigalla
I get a value in Char "00000012" but i need to replace the first character of the value with 'A'. Now the value looks like "A0000012'
What is the best way of doing it.

Posted: Thu Aug 23, 2007 3:17 pm
by ArndW
how about

Code: Select all

'A':RIGHT(In.Column,LEN(In.Column)-1)