hmmm...don't understand then why it works for any other university or sets of universities, except for this one that contains 'and'.

no problem...guess I should have been more distinct. Thanks for viewing.

this returns no records:

SELECT TOP 100 PERCENT LastName, FirstName, StaffAppID, Assigned_University

FROM ...

Well, as I said, I don't get any records returned at all (sqlserver 2000) if I only have one item in the IN statement and that item contains an 'and'....

Thanks for responding.....it doesn't return any records at all. But if I add another item (that doesn't have the 'and' in the text), it returns records containing both items.

I found only one issue....I've got a field in my db table that is encrypted for all rows. When I do my 'select' to retrieve data on my webpage...