Post reply

Arithmatic operation in string

  • September 20, 2012 at 2:59 am

    #281790

    declare @abc nvarchar(50)='500+200-100'

    select @abc

    from this I get, 500+200-100

    But How to get 600 ??

  • September 20, 2012 at 3:16 am

    #1539944

    Hi

    Here is one option:

    DECLARE

    @abc NVARCHAR(50)='500+200-100'

    ,@sql AS VARCHAR (50)

    SET @sql =

    'select' +' ' + @abc

    EXEC (@sql)

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply