On 25 November 2011 09:53, Soundfaction <[email protected]> wrote:
>
> I have a situation where I get different results for this:
>
> select ... where FUNCTION(X)>='Y'
>
> vs
>
> select ... where FUNCTION(X)>=FUNCTION('Y')
>
> And FUNCTION('Y') == 'Y' so I thought there should be no difference between
> the two queries.
How have you tested this? What result do you get from
select FUNCTION('Y') == 'Y';
>
> For some reason in the latter case it behaves as:
>
> select ... where FUNCTION(x)>'Y'
>
What do you get from select hex( FUNCTION('Y') )
Regards,
Simon
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
