I don't know how many tables and VARCHAR fields are in the database but the following command might help locate the rows. Select UniqueIdentiferColumn (SLEN(varcharColumn)) from Table where (SLEN(varcharColumn)) > 2000 You can play with the threshold number to reduce the data set. I believe you need 7.6 and up to use SLEN with VARCHAR. Jim
>>> "Heffelfinger, Duane" <[email protected]> 3/31/2009 3:28 PM >>> Good afternoon, Is there a way with R:Scope or a select trick to figure out what table is holding a large chunk of data in the .rb4 file? Even better can I figure out what table and row would be holding large VARCHARs values in the .rb4? Someone, somewhere has added several very large VARCHAR data chunks into the .rb4 and I would really like to know what table and row it’s attached to. Thanks for any ideas. Duey
