Thank's Peter,

marc

Although it seems to work of I change the BETWEEN to be:

BETWEEN '50000' AND '60000'

So I guess it was the BETWEEN that was doing the conversion and ignoring the restrictions...

I agree that it does not make sense ...

qSoldier is a view, but the same problem occurs off of the base table. The full query I am used (off of...

Thank's, Peter. At first I thought how simple a solution that was. Unfortunately it still gives an error:

Conversion failed when converting the nvarchar value 'NA' to data type int.

'NA' being...

Thanks for the suggestion, but I'm not sure what it would get me. Somehow I have to be able to get the data into the parameter for the Stored Procedure....