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

[Joel D Canfield]

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

<asp:SqlDataSource 
    ID="srcDIDs" 
    runat="server" 
    ConnectionString="<%$ ConnectionStrings:cnxHelm %>"
    FilterExpression="CONVERT(did,'System.String') like '%{0}%'" 
    ProviderName="System.Data.SqlClient"
    SelectCommand="select did from dids">
    <FilterParameters>
        <asp:ControlParameter 
            ControlID="SearchTerm" 
            Name="did" 
            PropertyName="Text" />
    </FilterParameters>
</asp:SqlDataSource>

> 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'
is.

Thanks, Ken.

joel