I created a DBC and added a stored procedure

FUNCTION NORSK(x)
RETURN CHRTRAN(x,ANSITOOEM('ÆØÅæøå'),'[\][\]')

then I could use a free table and index on this function.

open database data1
set collate to "machine"
use mytable
index on Norsk(name) tag name

I have never used stored procedures in DBC's, so this was new to me.




Aunes? We have many Aune here. Olav Egil Aune from Lillehammer and Per Aune from Røros.

Einar

>>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 ?
>
>I think the only hope of indexing on a UDF would be to use a Stored procedure. You might try creating a database container with your UDF, and use a connection string that points to that DBC. Then try to ExecuteNonQuery against the table using the UDF. This is a WAG, I admit.
>
>BTW, do you know any Aunes? <g>