>I would like to use a grid and be able to search any field for any instance of any text.
>
>For example, I would like to be able to type "ale ave" into the search field and have it search for any instance of "ale ave" in any field in the grid.
>
>it would find Glendale Ave, Pinedale Avenue, cloverdale ave suite 1......

A browse will already do that, as long it's character fields, not memo fields.

You can use the Ctrl-F find dialog from the command window to try it.