in reply to Datatypes. A Perl T-SQL comparison

Not that this is a perl question, but if your string contains only numbers, you should be able to do an implicit conversion. Observe:
declare @var nvarchar(3) set @var='123' select @var-10

thor

Feel the white light, the light within
Be your own disciple, fan the sparks of will
For all of us waiting, your kingdom will come

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.