From: "Leyne, Sean" <sleyne@...>

>
> The fact that the engine will convert integer values to strings is a
> convenience, it doesn't absolve the developers from using a little
> common sense when performing selects.

I tend to agree. I use a technique of adding leading zeros to certain fields
to get a true sort order for numeric strings. I make sure that when querying
the data, I always pad the parameters with leading zeros and use strings for
comparison. IMO, this is the only "true" way of working within this
scenario.

Woody (TMW)