Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
like query in ms access
October 22, 2010
how to write like query in ms access
Posted Date: October 22, 2010 Points: 5
Dude.. I think you have to use asterik (*) instead of percentage (%) symbol in query:
Eg: SELECT *
WHERE (((TableCustomer.[Name]) Like '*a*'));
Posted Date: October 23, 2010 Points: 5
Jet SQL 4.x supports the ANSI wildcards % and _
In Jet SQL, its
* for 0 or more characters (and from Jet 4.x you can also use %)
? for one character (end from Jet 4.x you can also use _)
Moral of the story is try both '*' and '%'
Hope this helps.
Thanks & Regards,
To post reply
Related Questions Related Questions
how to write Query to retrieve column names in ms access
Ms Access databse query
How do we use CASE WHEN statement in ms access query and please give me sample?
CASE WHEN Statement in MS Access query
getting Error for accessing Data from MS Access using Select Query
What is Code Access Security in .NET
query handling in asp
How 2 access Webcam through .Net
Having a doubt in SQL query
How to access the DLL that is in GAC
Latest Forum Questions From The Same Category
Xamarin for Visual Studio 2010/2012 ?
How to attach Google Plus authentication system in Windows 8.1 phone using c#
Installing Visual Studio 2012 on Windows 7
Can anyone suggests me a laptop on which I can install any OS ?
Software freelancers who work from home, need a license?
help me problem instal graphique card on i5 intel fujitsu e752 hd4000
Extracting data from different websites to excelsheet
Please let me know the cost/exam fee associated with the Microsoft ASP.Net certification
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend