hi guys this is the problem i'm facing, i have 2 tables with more than 50000 rows of data. i need to make a partial string match comparison( if possible % match). example Table 1 Item# Model Desc ------------ --------- -------- 001 Corola toyota 002 Camry toyota 003 Tundra Toyota 004 Avalon Toyota
table 2 Item# Desc ------------ --------- -------- 011 Toyota Camry is a japanese Auto 012 good mpg for corola 013 Copeting against US trucs - Tundra 014 Preimium brand Avalon the function should compare the "model" field from the first table against the "desc" field for a partila string and detrmines which row best matches help Thanks [Non-text portions of this message have been removed]
