Susan Harkins
ssharkins at setel.com
Thu Feb 1 10:11:53 CST 2007
That's because the wildcards for Jet SQL and T-SQL aren't the same. ADO's a problem too -- well, problem's the wrong word. You just have to know which wildcards the engine/library supports. http://articles.techrepublic.com.com/5100-10877-6154704.html See tips 8 and 9. Susan H. I have two tables in a query. One is a native Access table and one is a linked SQL Server table. The Access table has a 14 character text field. The SQL Server table with a 10 character text field. I verified all character positions are filled using a Len statement. When I join these two tables on these fields no matching records are found as expected. If I put a criteria using a wildcard (Like "PAT*") on another field in the Access table suddenly the two joined fields are equal. However if I use a wildcard criteria using the % sign (Like "PAT%") no matching records are found. Interesting! Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 9:04 AM