[SQL] Bug with DISTINCT?

[Eric Forget]

Hi,

I created one Table A with one field s1 (string[20]) with those values:

    '2004-01-15'
    '2004-01-14'

With the following query:

    Select RecID from A where s1 < '2004-01-15'

The result is:

    RecID
    2

Which is fine. However with the query:

    Select DISTINCT RecID from A where s1 < '2004-01-15'

The result is empty. I believe it should have returned the same thing with
this data. I've tried it with Vstudio.

Eric

___________________________________________________________________

 Eric Forget                       Cafederic
 ForgetE at cafederic.com             <http://www.cafederic.com/>

 Fingerprint <86D5 38F5 E1FD 5D9C 71C3  BAA3 797E 70A4 6210 C684>