adding a left function in there works for me. Since there is always one single quote at the end I can leave it hard coded.

Declare @TestData varchar(29)

Set @TestData = (SELECT...

ah, I see. how do you remove the non-numerics from the beginning and the end of a string? i.e. iFuturePriceID=N'4194582'

Thanks again.

yeah, similarly easy problem, it was the variable length I was giving it. Now I have another problem. It is returning the single quote at the end of the string,...

Hello,

I am working on a similar problem, however, this solution is not working right for me. I am hoping someone might be able to see why. When I use this...