User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 425,932 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,672 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 2031 | Replies: 2
Reply
Join Date: Apr 2006
Posts: 62
Reputation: Fenerbahce is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
Fenerbahce Fenerbahce is offline Offline
Junior Poster in Training

LIKE doesn't work in Access

  #1  
Jan 26th, 2007
Hi,

SELECT *
FROM veriler
WHERE (name LIKE '%in%')

This line doesn't work in Ms Access, IN either. No error is given is well. But It works in SQL server. How can i do in Access?

Thanks
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Apr 2006
Posts: 62
Reputation: Fenerbahce is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
Fenerbahce Fenerbahce is offline Offline
Junior Poster in Training

Re: LIKE doesn't work in Access

  #2  
Jan 26th, 2007
answer is
WHERE name LIKE ('*' & in & '*')
Reply With Quote  
Join Date: Feb 2007
Posts: 28
Reputation: Henry Schubel is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 3
Henry Schubel Henry Schubel is offline Offline
Light Poster

Re: LIKE doesn't work in Access

  #3  
Apr 4th, 2007
The Asterisk * is the wild card for the LIKE operator in Access.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MS Access and FileMaker Pro Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum

All times are GMT -4. The time now is 9:12 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC