Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Cleansing Expand / Collapse
Author
Message
Posted Wednesday, April 30, 2008 10:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 5, 2014 8:59 AM
Points: 21, Visits: 181
Hey guys i have and address field that needs to be cleansed. I have a reference table that has two columns. One column is the standard format and the other is the various incorrect format u may find.

I want to do a report just to show the before and after look of it after its been cleansed. What should i do.

report...

Address New Address
123 main street 123 main St
345 jack rd 345 jack Rd
etc
Post #493124
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse