SQL Server calculate string value

Question

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?

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

score 1 · Answer 1 · edited Jun 04 '21 at 10:13

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)

edited Jun 04 '21 at 10:13

Uwe Keim

38,279
56
171
280

answered Mar 14 '17 at 07:34

Mansoor

3,820
1
16
27

score 1 · Accepted Answer · edited Jun 04 '21 at 10:14

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)

edited Jun 04 '21 at 10:14

Uwe Keim

38,279
56
171
280

answered Mar 14 '17 at 07:34

udhaya kumar

161
6

SQL Server calculate string value

2 Answers2