> select * from mytable where a like 'b%'; > may be slow - even if a is an indexed column. > select * from mytable where a >= 'ba' and a <= 'bz'; > may be very fast. Ahhh, sorry, I meant:
select * from mytable where a > 'a' and a < 'c'; should be better... - Danny -- Danny Reinhold Reinhold Software & Services --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
