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

Joel D Canfield joel at streamliine.com
Sun Sep 16 01:08:58 CDT 2007

> any chance we could see the query, or should we guess?

here's a better idea: some groovy .NET thing like this seems to work

    CONVERT(assettag,'System.String') like '%{0}%'

gives me the filter I need

It's tough, when I can't tell if it's a SQL error or a .NET error.

Or a logic error, or a typo, or network issues, or data issues, or
PEBCAK, or lunancy, or . . .

More information about the thelist mailing list