Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Fuzzy Search with SQL?
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> -
CFMAIL
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>... -
ODBC Connection for Access 2000 and CF 4.0: Do you need 4.5?
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> -
Fuzzy Search with SQL?
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 "Colinsworth" as a parameter and the query would return... -
word score
the underlying result would be a name search that would return the closest name if an exact name isn't found- jwelch
- Post #6
- Forum: Microsoft: Access Other topics
-
word score
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...- jwelch
- Post #5
- Forum: Microsoft: Access Other topics
-
word score
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)...- jwelch
- Post #3
- Forum: Microsoft: Access Other topics
-
word score
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- jwelch
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
