DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Textbox Question

    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?

  2. #2
    Join Date
    Nov 2003
    Portland, OR
    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
    Phil Weber

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. Replies: 2
    Last Post: 12-12-2007, 09:03 AM
  2. Replies: 1
    Last Post: 07-07-2006, 05:37 AM
  3. Quick Stupid VB Question
    By GRapoza in forum VB Classic
    Replies: 2
    Last Post: 03-30-2006, 03:14 PM
  4. Appending To TextBox, Unique Question?
    By RPBLEA in forum Java
    Replies: 4
    Last Post: 04-27-2005, 08:20 AM
  5. Replies: 0
    Last Post: 11-02-2000, 08:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center