Open Dental Forum

Is it possible to delete all patients social security numbers in one report or one command? Insurance ID numbers used to be the patients social security numbers, but that has changed and I do not want to have the liability of keeping social security numbers. It's pretty time consuming to delete them one at a time. If anyone knows the answer, I would appreciate it.

It can be done in a query or just one sql statement.

If nobody helps you with this, I will after a bit.

Didn't think we could ever delete things in this version of mysql by design. Only hide. And that had to be done by OD central.

drtmz