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
Posted Wednesday, April 30, 2008 10:40 AM


Group: General Forum Members
Last Login: Saturday, June 6, 2015 6:50 PM
Points: 21, Visits: 185
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.


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

Add to briefcase

Permissions Expand / Collapse