Hi, We have a problem with lower() function working differently for two
different data types

table: yuva_test
column_name	data_type
yt_name1	varchar(255)
yt_name2	char(1)

The data is
yt_name1	yt_name2
yuva		F
bharat		F
1234556	F
234		F

etc.

When we run the query "select * from yuva_test
lower(yt_name1)=lower('1234556') and lower(yt_name2)=lower('F')" it takes
forever to return, but if try "select * from yuva_test yt_name1='1234556'
and lower(yt_name2)=lower('F')" it returns immediately.

What is happenning here? Why lower behaving differently for varchar(255) and
char(1), and how to make first query to work without changing schema.

Thanks
Yuva

Fri, 9 Aug 2002 15:40:52 -0700 
Yuva Chandolu <ychandolu@ebates.com>
Problem with lower() function