Recent content by jwelch

this really doesn't help because how am i supposed to know each variation of the user input and then put that into a sql statement? How am i suppose to figure out colinsworth, collins, etc from the user input of 'collinsworth'?<br>

are you sure you have the correct smtp information? Is mail forwarding turned on by your administrator? Does your smtp mail have to orginate from a email address from your company? <br> <br> Try putting a from email address that is valid in your tag.<br> <br> Try checking the smtp info.<br> <br>...

No, you just need the latest version of MDAC. get it from <A HREF="http://www.microsoft.com/odbc" TARGET="_new">www.microsoft.com/odbc</A> you need to have version 4.x for Access 2000.<br> <br> The new version of the MDB ODBC driver will work with both 2000 and 97 versions of mdb files.<br>

Using SQL with a ODBC source...<br> <br> Is there a way that I can create a query that will return a word approximate score such as: (refering to a table with first_name (text), last_name (text), ...<br> <br> A user could enter &quot;Colinsworth&quot; as a parameter and the query would return...

the underlying result would be a name search that would return the closest name if an exact name isn't found

The user would enter a first and last name or just one of the two, and the query would return records with a score of how close the fname and lname matched. <br> <br> If there is an exact match of first name and last name then the score would be 100%, if only first name or only last name then...

Sorry, for some reason the last post got truncated.<br> <br> <br> Using SQL with a ODBC source which is a Access2000 database...<br> <br> Is there a way that I can create a query that will return a word approximate score such as: (refering to a table with first_name (text), last_name (text)...

Is there a way that I can create a query that will return a word approximate score such as: (refering to a table with first_name (text), last_name (text), ...<br> <br> A user could enter