Page 1 of 1

Concatenate to an integer

Posted: Thu Dec 23, 2010 11:11 pm
by Shruthi
We have a requirement when we have to concatenate a value to integer.

Input is 1999
Output should be 11999

How to concatenate this?

Posted: Fri Dec 24, 2010 12:29 am
by Sreedhar
Hi,

add 10,000 to the given value.....

Posted: Fri Dec 24, 2010 12:36 am
by jpraveen
Hi,

convert the integer into varchar and then concat it.

Posted: Fri Dec 24, 2010 1:42 am
by Shruthi
I wanted to avoid conversions as they are giving lot of confusions. adding 10000 is a great idea. will go ahead and use this. Thanks