[thelist] ASP.NET 2.0 and MSSQL - using 'like' with Int32

Joel D Canfield joel at streamliine.com
Sat Sep 15 16:12:29 CDT 2007


I have a form field for a search term, and I want to search a bunch of
fields from different tables for any occurence of that term.

I can use like '%searchterm%' against Int data types in Query Analyzer,
but .NET balks.

I don't care about the data type while searching, but can't figger out
how to view those db fields as strings. Using CAST or CONVERT in my
query throws an error about those functions not existing.

Thoughts?

Thanks muchly.

joel



More information about the thelist mailing list