title: 9 million rows in my table that needs Address Scrubbed Is a CLR UDFSclar Function be better Than a SQL Server UDF?
body: <p>I have a performance question.  I need an Address Scrubbing routine.  My table has Almost 9,000,000 rows. Would a UDF in SQL Server with 80 Replace Commands VS a CLR Scalar Function VS a CLR Table Call VS a Web service Call to the POST office be more efficient? </p>