>No problem. So, I guess I'm back to creating an index.

Dan,

Have you looked at the execution plan if you do:

WHERE '12345' LIKE ZipCode ???

That should match the first 5 chars only and use the index.

BOb