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
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center