Hey dnf999,

I was just asked to set up a DB that would allow our customers to store docs as well.  We never thought about making them searchable.

Very good thinking!  I...

Thanks Lowell,

I was trying to automate this too.

I have many denormalized tables I am trying to shrink...

250 to 325 fields.. not pretty!  I was hoping to use variables to read...

You can also add:

and crdate not between X and Y

add o.crdate to your select and you'll see what to do.

Hope this helps!

Gene

This is FANTASTIC!  Great Job Gary.

I have the same question as Carlos,  8K limit!

I have one denormilized table that this doesn't really work on.

I changed the data type of the...

If the structure is the same,  I have done it.

When it asks what to clear/reset do not select anything!

The other option is to do a "disconnected" edit. 

This is a...

How about,

Order by len(COLUMN),Column

I just did a quick search on TEXTCOPY...

This looks like the answer!!

Thanks Allen