Re: Weird results from WHERE clause ...

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

Could this be due to decimal precision?  For example, 50.0000001 <> 50 
but might compare differently in a between construct.

Sam

On 5/12/2016 11:53 AM, Jon Paris wrote:
> This is running in Run SQL Scripts.
>
> Note my earlier comment - the ONLY difference between the working and non-working versions is that we changed the final part of the statement from:
>
> WHERE UniqueId BETWEEN 50 and 50;
>
> to
>
> WHERE UniqueId = 50;
>
> That is the ONLY change I promise.
>
> The first one works correctly - the second doesn’t.
>
> Note also that the non-working version does not fail to return a result - it just doesn’t return any values - they are all blank/null other than the UniqueId itself.
>
>
> Jon Paris
>
> www.partner400.com
> www.SystemiDeveloper.com