From time to time, as we distribute tables across our network we are afflicted with a problem: randomly, data in character fields is lost and the individual characters are each replaced by chr(0). To identify tables with this problem we have code to scan our tables record by record, character field by character field until an occurence is found. It occurred to me that there might be a different way to code this.

Q1: Is there some low-level approach to locating occurences of chr(0) in our table fields? If so...

Q2: Would it be faster than our current approach?

Thanks