Textbox Question

[Cola]

I have a text box in ASP.NET 2.0 that the user is entering search strings in. The search strings are numbers but they need to have the wildcard ablility.

I take in the text pass it to a stored procedure that does a like to it....

So the user enters %23 to get all the items ending in 23 and ASP sends a # to the procedure.

How do I stop this from happening?

[Phil Weber]

How is the data stored in the database? You cannot use wildcards with numeric data, only text. To find numeric values ending in 23, try this:

SELECT columns FROM table
WHERE numericColumn % 100 = 23