Stange behaviour in fuzzy lookup

Hello.

I'm trying to use fuzzy lookup in order to create a dimension populated from two operational tables.

The codes in table 1 are like the ones bellow:

PT, UK, NL, etc

The codes in table 2 are like thw ones bellow:

PT0, UK0, NL0, etc.

The only difference between them is the zero at the end of the corresponding code. I tried using fuzzy lookup to match the results, but even with both the column's minimum similarity set to 0 and the similarity threshold in the advanced tab set to 0, no matches are found.

If I create a view from table 2 and set the codes to SUBSTRING(table2_code, 1, 2) everithing works fine.

I believe it should work either way, since PT is pretty close to PT0. Could someone please point out where I'm going wrong

Thanks in advance,

Hugo Oliveira