what will be d output of the following code segment?

Hi Anjali,

if you are looking to concatenate values then use varchar .

"+" operater will concatenate both .

 

use this query 

 this will give 546875.5100 as result.

 

If you are looking to Add values then use Decimal instead of char. 

This will give 546975.50 as result.

 

Hope this helps

Output will be 546875.5.

 

Becuase you are using Char datatype of length 10, your variable will be padded with spaces at the end of the number. In this case length is 8 and it will add two extra spaces at the end. And hence, when you try to use + operator, it won't really merge strings becuase the length of combined string is more than what @my_name can hold. 

 

And if you really want to join them together, instead of doing cast, you can use CONCAT function that does casting for you.