Different behavior in comparison

[Ernesto Giannotta]

Hi Ruslan,

here's what I found:

T_1 has 1 field (string) and 2 records
#1	F_1 = '_'
#2	F_1 = 'A'


  select * from T_1 where F_1 > '_'
	returns record #2

  select * from T_1 where Left(F_1, 1) > '_'
	returns no records

  select * from T_1 where 'A' > '_'
	returns no records


So I guess collation used for comparison of fields (tertiary as in  
default) is different from the one used comparing strings

I guess in fact that Left(F_1, 1) takes a string from the field and  
performs comparison on it (somewhat different from the one used with  
F_1).



Cool Runnings,
Erne.