• All my systems are medical records, and also have personal data like SSNs and birth dates. Basically every thing you need to do identity theft.

    so I can't use production data to test for more than 90 days.

    What I've been looking for is something similar to a ROT-13 SQL function to scramble the data, but haven't been able to find one.

    So the problem always is that the test build data set is always small and not anywhere near an example of production data. So it has always been an emergency tuning the new sprocs and production SW.



    ----------------
    Jim P.

    A little bit of this and a little byte of that can cause bloatware.