Different behavior in comparison

[Ruslan Zasukhin]

On 8/18/09 8:56 PM, "Ernesto Giannotta" <ernestogiannotta at tiscalinet.it>
wrote:

Hi Erne,

I see you have report it to Mantis.
Thank you.


> 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).


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]