Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Access 2003: Match Function
Posted on 2008-10-05
SELECT MATCH(table1) AGAINST (table2) as Relevance FROM table
as i understood .. match is not available in access/sql. Is it possible to get this function in Access 2003?
i have Levenshtein in a vba function working in access.. but i want to compare it to the match function from mysql
as i understood .. match is not available in access/sql. Is it possible to get this function in Access 2003?
i have Levenshtein in a vba function working in access.. but i want to compare it to the match function from mysql
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
5 Comments
>as i understood .. match is not available in access/sql
correct.
you will have to use some "real" database engine like MySQL, MS SQL Server, Oracle etc which do support full-text indexing.
are you aware that you could use ms access as front-end, and keep the database in MySQL, and with pass-through queries use the MATCH() function?
correct.
you will have to use some "real" database engine like MySQL, MS SQL Server, Oracle etc which do support full-text indexing.
are you aware that you could use ms access as front-end, and keep the database in MySQL, and with pass-through queries use the MATCH() function?
> i have Levenshtein in a vba function working in access
note that such a function cannot use any index on the tables, so will do result in a full table read ... not really coool...
note that such a function cannot use any index on the tables, so will do result in a full table read ... not really coool...
thanks for the response
the match function of mysql is available right? (open source). i could rewrite that code to vb.. perhaps anyone did this allready?
the match function of mysql is available right? (open source). i could rewrite that code to vb.. perhaps anyone did this allready?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In part one, we reviewed the prerequisites required for installing SQL Server vNext.
In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 6 hours left to enroll
627 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.