CODEWITHSUNDEEP
sql-server
Antony
Antony

Reputation: 976

SQL Server calculate string value

Declare @table table
(
    Col1 varchar(50),
    Col2 varchar(50)
)

insert into @table
    select '100', '*10+2'

select Col1 + '' + Col2 
from @table

Expected output is: 1002

Can you please help?

Upvotes: 0

Views: 1470

Answers (2)

udhaya kumar
udhaya kumar

Reputation: 169

Use like this:

Declare @table table
(
Col1 varchar(50),
Col2 varchar(50)
)
Declare @Out varchar(100),@Query varchar(100)=''

insert into @table
select '100', '*10+2'

select @Out= Col1 + '' + Col2 
from @table
SET @Query = 'SELECT ' +@Out
EXEC (@Query)

Upvotes: 2

Mansoor
Mansoor

Reputation: 4192

Use EXEC SQL query:

Declare @table table
(
  Col1 varchar(50),
  Col2 varchar(50)
)
DECLARE @Cal VARCHAR(100)

insert into @table
select '100' , '*10+2'

SELECT @Cal = Col1+''+Col2 from @table
SELECT @Cal = 'SELECT (' + @Cal + ')'
EXEC (@Cal)

Upvotes: 1

Related Questions