On Mon, 20 Oct 2003 14:36:20 -0700, Alan Wolfe wrote: >hello, sorry if i should just rtfm but i was wondering, last night i heard that you could set up an index on multiple columns without storing the concatenation of those columns.
Alan, Yes, it's part of SQL: CREATE INDEX mynewindexname ON tablename + (firstcolunmname, secondcolumnname) There are syntax variations for unique indexes, and for descending indexes. If you decide to read the fabulous manual, look under CREATE INDEX. Bill
