How does the parameter get sent?
>I do add parameters through Parameter statement, but the parameter uses @ in its name, e.g.
>
>select top (1) devicetype from dbo.pmt_type where @CardNum between Range1 and Range2
>
>This is my query string. I used @ to put the whole string into 1 variable.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer