Cannot match same data in different tables

[jitendrakalyan]

I have a rather peculiar problem. I have country codes and coutry names listed in a table1. And countries listed in another table2. All i need to do is to update corresponding country codes in table2 . I have written the following query.

Update Table2,Table1 SET Table2.Countrycode = Table1.Code
WHERE Table2.Country like '%Trim(Table1.Country)%';



This does not update any records in my Table2. Physically I can see that the country names are spelled out exactly same in both tables . I don't understand what could be the problem. Could it be the encoding (Eg: Unicode, ANSI) etc.

Let me know Thanks

Jitendra

[pbaldy]

You're trying to match the literal string '%Trim(Table1.Country)%'. Presuming you don't need the wildcards try:

WHERE Table2.Country = Trim(Table1.Country)

if you do, try:

WHERE Table2.Country like "'*" & Trim(Table1.Country) & "*'"

[jitendrakalyan]

Thanks pbaldy. It worked .

[pbaldy]

Happy to help, and welcome to the site!