I have a field in my table that provides description for vehicles (Cars, Trucks, Vans, etc.). Unfortunately the descriptions are not all uniform....
Example: CAR#61 CAR # 124 CAR# 469 TRUCK#123
I need the data to read as follows:
CAR#XXX - No spaces, if the car is under the digits zero fill to make 3 digits. Example:
CAR#3 should read as
I just need this for the Cars. Trucks, Vans, etc. shouldn't be changed at all.
Also, I just have 'read-only' access on the DB so I cant do updates to the table. I need to pull the data through a SELECT query (Oracle Database).