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?
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
Please post questions to the forums, where others may benefit.
I do not offer free assistance by e-mail. Thank you!
By Matrix.net in forum ASP.NET
Last Post: 12-12-2007, 10:03 AM
Last Post: 07-07-2006, 06:37 AM
By GRapoza in forum VB Classic
Last Post: 03-30-2006, 04:14 PM
Last Post: 04-27-2005, 09:20 AM
By Marat Musaev in forum XML
Last Post: 11-02-2000, 09:54 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL