what will be d output of the following code segment?

Question

hi frnds wt is the output for the below code ? declare @my_name char(10) = 546875.5 set @my_name = @my_name + '100' select @my_name

Tapan Patel · Answer

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.

Ankit Sharma · Answer

Hi Anjali if you are looking to concatenate values then use varchar . + operater will concatenate both . use this query declare @my_name varchar (11) = 546875.5 set @my_name = @my_name + CAST (100 AS varCHAR (11)) select @my_name this will give 546875.5100 as result. If you are looking to Add values then use Decimal instead of char. declare @my_name Decimal (102) = 546875.5 set @my_name = @my_name + CAST (100 AS Decimal (102)) select @my_name This will give 546975.50 as result. Hope this helps