Hi!
Do you use collating sequense setting for your indexes? Take a look to the SET COLLATE command. Indexes created after SET COLLATE work by different way. Try them. If you already use collating sequense, than it could be a source of your problem. Just look around it.
>The seek command does not seem to work with some accented characters in my setup. I have not 100% tested the scale of the problem yet but ë and Ö do not always locate correctly. Do I need a special collation in the indexing to make the basic seek work? I thought not. Many thanks in advance.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.