You cannot do partial matching in SQL Server this way. You have to use LIKE for partial matching.

>
>I am sending an select statement over to SQL Server 2005 with an in() in the where statement. I thought it would be like VFP, but am thinking I am wrong now.
>
>I am trying to do parshal (sp? - not full) matching on the items in side the in.
>Do I have to do the %, or should in() work?
>
>TIA,
>Beth