Like '*Varified*' "

Last post 07-04-2008 10:08 PM by kenbati. 2 replies.

Sort Posts:

  • Like '*Varified*' "

    07-04-2008, 5:47 PM
    • Loading...
    • kenbati
    • Joined on 01-30-2007, 12:54 AM
    • Posts 265

     

    AccountDataSource.DataFile = "~/App_Data/AccountInfo.mdb";

    AccountDataSource.SelectCommand = "SELECT myTable.* FROM myTable Where myTable.Notes Like '*Varified*' "

    The above query works in msAccess but does not give results or error in asp.net.  I am using OleDB. What should I do? thanks

    Without your help I can do nothing. When I help you and you can do something then do not forget to mark it as answer!!
    Filed under:
  • Re: Like '*Varified*' "

    07-04-2008, 6:24 PM
    Answer

    Change the * to %

     

    Regards Mike
    [MVP - ASP/ASP.NET]
  • Re: Like '*Varified*' "

    07-04-2008, 10:08 PM
    • Loading...
    • kenbati
    • Joined on 01-30-2007, 12:54 AM
    • Posts 265

    thanks, that worked!

    Without your help I can do nothing. When I help you and you can do something then do not forget to mark it as answer!!
Page 1 of 1 (3 items)
Microsoft Communities
Page view counter