Thanks Sergey,
I like your idea and we have taken that one step further. The field is a 7 charachter field. If we force them to use at least 3 charchters we can create 5 indexes on the possible positions and run a select for each possible position.
Thanks,
Jim
James Harvey, MCP
Memphis Police Department
225 Channel Three DR
Memphis, TN 38103
901 577-1296