Looks like it could be solved by explicitly selecting the string as part of a dynamic SQL statment.
Something like:
DECLARE @String VARCHAR(10), @Cmd VARCHAR(1000);
SELECT @String = '10*5';
SELECT @Cmd = 'select ' + @String;
EXEC(@Cmd);
SELECT @String = '10.5'
SELECT @Cmd = 'select ' + @String;
EXEC(@Cmd);
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon