arthurh88
asked on
SQL update statement based on a formula?
in my table PostalCodes i need to select all Postalcodes from dbo.postalcodes where LEN = 4, and then add a leading 0 (zero) in front of value and re-update it.
For example, postal codes in the table that look like this: 7712 should actually be 07712
Anyone know how to do this?
For example, postal codes in the table that look like this: 7712 should actually be 07712
Anyone know how to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER