01-11-2010 01:06 PM
I've been asked by a support group to look into correcting data corruptions that may have occurred in their client's system, and whose corruption is likely to similar in each instance (for example, all data in Field A between Date X and Date Y are missing the first letter).
I am looking for a way to query the data to verify the nature of the corruption and to create a custom query to repair the data to its original state. SQL equivalents needed are for the SELECT and UPDATE commands.
Thanks in advance.
01-11-2010 10:31 PM