I need a script that will search a database table and return the results in ASP

Posted on 2008-11-05
Last Modified: 2012-05-05
I need a script that will search a database table and return the results in ASP. I have a database I want to search and I want to be able to search by title but not have to put in the full title for a match to come up, just have it list all matching records.
Question by:josgan
    LVL 7

    Accepted Solution

    Here's the sql for that.

    select * from tablename where fieldname like '%partial_string%'
    LVL 36

    Assisted Solution

    by:Loganathan Natarajan

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    The first time you look at a web page and its source code, you are probably a little intimidated by the use of symbols and jargon that really looks foreign to you. You might not even know where to start to begin learning what it all means. That’…
    I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
    The viewer will learn how to dynamically set the form action using jQuery.
    The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now