generally this is not unique to crystal and has more to do with what logic would you want to apply to flagging these records. Form there it comes to how would you do that in crystal. Also how do you stop flagging them once you have reviewed the infomation and determined it to be OK.
Do you knly have title or do you also have author?
do you have a set of data that is more reliable and you wnat to use to check against 'newer unvalidated' data and is there something your your data set that you can use to differentiate these rows?
Lockwelle would likely use a stored procedure to do this and I would lean toward that as well. It would be easier in that to add the table as many times as you need to using a master table of 'good or scrubbed data' to check agains t various version of the 'new unscrubbed data' joining on LIKE statements multiple joins on author last name and partial title match, titel matches when replacing all puncuation with a space, etc.
IP Logged
