Home ›
ASP.NET Forums » Data Access » Oracle » How to search Products in a database table?

How to search Products in a database table?

Last post 09-07-2009 4:30 AM by vik20000in. 1 replies.

Sort Posts:

  • How to search Products in a database table?

    09-07-2009, 3:34 AM
    • Member
      53 point Member
    • Mobzam
    • Member since 05-22-2008, 4:00 AM
    • Posts 479

    Hello People,
    I am developing web application using csharp. How can I write an sql for oracle that picks products records that starts with letters typed in text box? For example when I type p all products that starts with  p are dispalyed?
    Please help

  • Re: How to search Products in a database table?

    09-07-2009, 4:30 AM
    Answer
    • All-Star
      22,266 point All-Star
    • vik20000in
    • Member since 12-30-2005, 6:02 AM
    • Kolkata
    • Posts 3,464
    • TrustedFriends-MVPs

    select * from producttable

    where columnname like 'Valuetyped by user' + '%'

    Vikram
    www.vikramlakhotia.com


    Please mark the answer if it helped you
Page 1 of 1 (2 items)
RSS Available

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.