<div>
&gt;as i understood .. match is not available in access/sql<br />
correct.<br />
<br />
you will have to use some &quot;real&quot; database engine like MySQL, MS SQL Server, Oracle etc which do support full-text indexing.<br />
<br />
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?
</div>


>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?

<div>
&gt; i &nbsp;have Levenshtein in a vba function working in access<br />
note that such a function cannot use any index on the tables, so will do result in a full table read ... not really coool...
</div>


> 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...

<div>
thanks for the response<br />
<br />
the match function of mysql is available right? (open source). i could rewrite that code to vb.. perhaps anyone did this allready?
</div>


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?

<div>
<div class="content wysiwyg-content">
SELECT MATCH(table1) AGAINST (table2) as Relevance FROM table<br />
<br />
as i understood .. match is not available in access/sql. Is it possible to get this function in Access 2003?<br />
i have Levenshtein in a vba function working in access.. but i want to compare it to the match function from mysql
</div>
</div>


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

Access 2003: Match Function

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.