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

Reply via email to