Access Query Using Like "*" & [@input] & "*" Problem! RSS

• • Reply
  •  
  

  chrisjreoch

  Member

  40 Points

  8 Posts

  Access Query Using Like "*" & [@input] & "*" Problem!

  Nov 01, 2003 06:04 PM|LINK

  Dear Readers, I have a query that I input values to and return results. In my query criteria I have Like "*" & [@input] & "*" . When I run the query in Access everything works fine. It returns results for everything that matches "chr" which includes "chris","Christine","christ", etc.... When I run the stored procedure in asp.net it returns no results and no errors? Any suggestions???? try objcmd.connection.open() objreader = objcmd.executereader while objreader.read response.write("
  Id=" & objreader("custid")) end while catch ex as OleDbException response.write(ex.tostring) end try
• • Reply
  •  
  

  douglas.reilly

  All-Star

  23305 Points

  4647 Posts

  Re: Access Query Using Like "*" & [@input] & "*" Problem!

  Nov 01, 2003 07:15 PM|LINK

  Try using % rather than *. OleDb uses the standard wildcard characters, % for one or more of any character, and _ for one of any single character.
  Starting with ASP.NET 2.0? Look at:
  Programming Microsoft Web Forms
  My Blog
• • Reply
  •  
  

  chrisjreoch

  Member

  40 Points

  8 Posts

  Re: Access Query Using Like "*" & [@input] & "*" Problem!

  Nov 01, 2003 09:14 PM|LINK

  Dear Douglas/Readers, Thanks, that worked! It sorta funny that when I used the query in access it returns no fields for a search. But the same search via asp.net returns values perfectly. Thank you very much for your help. Query Criteria Looks Like: like "%" & [@input] & "%"
• • Reply
  •  
  

  amityksharma

  Member

  2 Points

  1 Post

  Re: Access Query Using Like "*" & [@input] & "*" Problem!

  Nov 04, 2009 11:15 AM|LINK

  Hi ! This query using Like Keyword in msaccess 2007 is working .

  
  

  select * from tablename where po like '*'+'value'+'*'

  
  

  
  

  
  

  Amit Sharma