At 03:30 PM 12/8/2010, Coxen, Dayle wrote:
Any suggestions how to best re-work this code replacing the BUILD command?
Dayle, Use CREATE INDEX command to achieve your goal. Syntax: -- For a TEXT column CREATE INDEX indexname ON tablename (columnname SIZE nnn) -- For a numeric column CREATE INDEX indexname ON tablename (colname) For more details and examples: HELP CREATE Very Best R:egards,Razzak.

