• You can include any number of them in an index. You can't have them as the key columns for the index. It's really as simple as that.

    Often, you're better off using a full text index on that kind of column, instead of a regular index.

    What problem are you trying to solve by indexing these?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon