I have a field in my table that is 14 characters long and may have digits in random positions within the field. I need to select the field and have zeroes replace all of the blank spaces
Original field Padded with spaces
1 2 3 00100200300000
3 1 00030010000000
Can somebody please help with developing a query to satisfy the requirement.
View Complete Post