> I can use like '%searchterm%' against Int data types in Query Analyzer, but .NET balks. so should QA, i'm surprised it didn't > Using CAST or CONVERT in my query throws an error about those functions not existing. any chance we could see the query, or should we guess? ;o)