Ray Jenkins wrote:

> We are in a situation because of a customer request where we are going
> to be searching on a string value, my question is whether this will be
> slow compared to searching on some sort of id? If we spend some extra
> time programming we could arrange to use an integer value as our key.
> So, I was just curious how an index on a char field performed?
>
> Thanks in advance
> Ray

If your customer wants to search on a string value - why not.
This doesn't stop you from using integers as primary keys.
Never mix customer logic with your primary keys!

Uwe