Li li,

That is what I thought. So I went into the table and check them. I even cut
and paste from one to another. Did not work.

Mark

-----Original Message-----
From: Li Li [mailto:lilinola@u...]
Sent: Monday, June 11, 2001 5:09 PM
To: sql language
Subject: [sql_language] Re: [problem with grouping]


I guess the value are actually different even stored date in xx/xx/xxx
format.
 The seconds that not display may different.  Check them?

Li li



"Mark.Chen" <Mark.Chen@s...> wrote:
Hi,

I have encountered the weirdest problem in SQL.

I have a table with a field to store date in xx/xx/xxxx format. The data
type is nvarchar.

I was attempting to GROUP BY this field. Then I found that the result
separate the records with same date! I tried again with SELECT DISTINCT, it
still does the samething: same date, different records!

All other fields in this table grouped fine except for this one. This is
driving me crazy!

Anyone has a remedy to this?

Mark