 |
 |
Archives of the TeradataForum
Message Posted: Mon, 12 Feb 2007 @ 09:47:25 GMT
| Subj: | | Re: Accent Insensitive Matches |
| |
| From: | | Mario Galante |
| | What about building an associative table with a row for each possible derivation and pointing them to a common value and doing a join to
it? | |
Thanks for the suggestion, but I'm afraid it's not really an option in my case. This solution would work just fine for a relatively small table
whose fields have a finite number of possible values. The challenge would be to create this associative table for a huge table on (say) a name or
address field. In this case, the number of possibilities will go through the roof, making this solution impractical.
| |
