Varchars and indexes

To all: I recently had a discussion with a data architect about the consequences of VARCHAR fields used in indexes. I would appreciate some comments from you all regarding performance impacts when using the VARCHAR data type in an index. Thanks in advance... ( and please post your comments even if you email me off-line, the information should be shared ) :-) -- Tim Schaefer \\\\|// tschaefe@mindspring.com (6 6) Orlando, FL, USA, Earth -------------------------------oOOo---( )---o00o-------------------------------- WWW: http://www.mindspring.com/~tschaefe Liberty: http://www.lp.org Informix FAQ: http://www.iiug.org --------------------------------------------------------------------------------