SQL Address Correction over the web (CASS)

I just wanted to share that we have finished building our Address Correction program to CASS certify records directly inside SQL over the internet.

We have deployed it into our daily triggered mailings so that every record a customer transfers to us is cleaned and updated to the USPS Addressing standards, zip+4 etc

We are updating Canadians in the same pass.

To Expand on the possibilities…
This means that we could connect this CASS program directly into a timed process with any customer to clean their internal databases as well.

What if a Casino uploaded their new signups to us each day, me cleaned and mailed them, then they import those database changes back into their system?  This would be easy to do at this point.  Too easy.

I would suggest going deeper and query:
SELECT TOP (1000) *
FROM dbo.PLAYERS
WHERE [ZIP] EXCLUDES *-*

They could send us 1000 records per day where zip+4 has not been coded.
This could be a nice daily cleansing ritual that runs Hands-Free and over the course of 30 days their database would be pristine. Plus it would continue to check for records to clean each day so it always stayed pristine.

Another milestone of capabilities for us here at CSG.

Never stop learning and growing!

One thought on “SQL Address Correction over the web (CASS)

  1. Absolutely amazing, especially for new players! Good way to get them back right away! Not only that, but the data is used right away; instead of it ending up in an inactive list 6 months from when they first signed up.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>