Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Yesterday @ 11:35 AM
Points: 21, Visits: 203
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