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

[r937]

> here's a better idea: some groovy .NET thing like this seems to work
>
>    CONVERT(assettag,'System.String') like '%{0}%'


well, if that works for you, then assettag must be a user-defined sql server
datatype

the sql server syntax is --

    CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

see? first parameter is non-optional, and must give a valid datatype

what was your question again?

;o)