BTW that function is in fact a single liner that you could directly use in indexing. ie:
index on chrtran(myField,"localcharlisthere", "mapchars") tag myTag
Doesn't need a stored proc and could be done VFPOLEDB.
Cetin
>Yes, this is just the same thing. You like to map the Ýý to II where I would say Yy. But how can you index a free table on TrMatch() using OLEDB ?
>
>Regards,
>
>
>>Einar,
>>Actually I couldn't use sys(15) myself and created my own mapping. For a sample check:
>>
http://fox4um.com/forums/read.php?f=3&i=10341&t=10273>>You'd have problem with the language but code is understandable I think.
>>That approach is also usable via .Net with OLEDB.
>>Cetin
>>
>>>>Cetin