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.
I'm not exactly sure what you are trying to do, but this would perhaps give you an idea:
update table set field=substr('00...0' || field, -20, 20)
assuming you want your fields padded to 20 characters wide. Here
'00...0' is a string consisting of 20 '0' characters.
Igor Tandetnik
