Re: 2006-07-26 00:00:00
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 28 Jul 2005 21:49:17 +0000 (UTC)
Fernand St-Georges (fernand.st-georges@xxxxxxxxxxxx) writes:
> This is the result I get in Word as I handle a document that merges data
> from the database. The field «Date_Fin_Membre» returns me this result
> even if the query stipulates
> WHERE (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
> dbo.Membre.Date_Fin_Membre, 101)). I have also tried other types of
> conversion without any success.
Maybe you could explain what's wrong with the result? Maybe it's an
error to you that the end date for a member is in the future, but I
don't know your business.
If you are talking about the time portion, then the WHERE clause is not
the place to handle it.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.
- References:
- 2006-07-26 00:00:00
- From: Fernand St-Georges
- 2006-07-26 00:00:00
- Prev by Date: Re: recreate system tables
- Next by Date: IF ELSE with WHERE, AND, OR
- Previous by thread: Re: 2006-07-26 00:00:00
- Next by thread: Msg 512 but no duplicates!?!
- Index(es):
Relevant Pages
|
