Well that doesn't make much sense. Can you make an index on the column? On 9/2/05, R S <[EMAIL PROTECTED]> wrote: > Hi, > I tried using LIKE instead of = on a varchar column and found the results > astonishingly quick? > > select * from table where columnname LIKE 'abcd' > is far quicker than > select * from table where columnname = 'abcd' > > Is this true? > Thanks > >
-- Cory Nelson http://www.int64.org