First you need to add match codes to your database lookup table (the one that the SQL Lookup node references). Create name match codes and insert them into this table. Then when you are testing with the external data provider node, add a match code node for the name (using the same definition and sensitivity as you used in appending match codes to your lookup table.). When you are testing perform the SQL lookup on the match codes and not on the exact names. The following records will return when you enter smith - smithi, SMITH, SmItH, simithe, etc. -shawn
... View more