It took a lot of effort to rewrite my app from VB.Net to C# so I could use the example Paul supplied above, but it worked like a charm!

Thanks Paul!

Trevor

Thanks Darrell, but I've already been though that one. One would think that if MS included and add method, there must be another collection available.

Trevor

When you use the "IN (@SQL)" syntax, you are literally looking for "fclty_code = @SQL" which is to say, fclty_code="'LMTO','MMAG'" so it does not find any records.