0
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?

Uwe Keim
  • 39,551
  • 56
  • 175
  • 291
Antony
  • 966
  • 8
  • 19
  • Have you written any kind of parser for this? Also, try this: http://stackoverflow.com/questions/9850894/string-expression-to-be-evaluated-to-number – owczarek Mar 14 '17 at 07:23

2 Answers2

1

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)
Uwe Keim
  • 39,551
  • 56
  • 175
  • 291
Mansoor
  • 4,061
  • 1
  • 17
  • 27
1

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)
Uwe Keim
  • 39,551
  • 56
  • 175
  • 291
udhaya kumar
  • 161
  • 6