Have you looked at the collating sequence options? perhaps you can get it to sort how you want without the padding.
On 12/29/05, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Brian Johnson wrote: > > I need to update a char field to add integer prefixes, but I need to > > pad them with zeroes so I can sort them. >
