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

Joel D Canfield joel at streamliine.com
Mon Sep 17 08:32:58 CDT 2007

> Can you provide a greater code snippet please (and also the 
> SQL Server version you are using)?

    ConnectionString="<%$ ConnectionStrings:cnxHelm %>"
    FilterExpression="CONVERT(did,'System.String') like '%{0}%'" 
    SelectCommand="select did from dids">
            PropertyName="Text" />

> Either CONVERT() is being called inside SQL Server (in which 
> case it must use the syntax provided by Rudy), or it is being 
> called inside .NET (Convert is a class in the System 
> namespace).

Well, it's SQL as Visual Studio has written it for me. I couldn't tell
you which of the above that means, only that, as it's written, it
returns the expected results.

> but perhaps it has an overloaded signature that allows you to 
> use the way you are using it.

If that means *I've* set something up to allow this, I assure you I
haven't ;) If it's important for me to know what that means, please
explain it, 'cause I don't have a clue what an 'overloaded signature'

Thanks, Ken.


More information about the thelist mailing list