Hi 549,

You are correct. You can have a faster query by searching integer rather than string. I agreed. But What I wanted to show is the way.

And in my example, if '000500' is really need, then of course you have to use it. Or else you have to cut all leading zeros for searching and use replicate for querying. Can agree?

MCP MCSE MCSD MCDBA