You can use CASE in all sorts of places, like JOINs, SELECT, WHERE and
others - a damn useful command <g>
> -----Original Message-----
> From: Eric Creese [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 12, 2003 10:48 AM
> To: CF-Talk
> Subject: RE: SQL date conversion issue
>
>
> There are no NULL values but I think the problem may be the
> fact that I have the dates stored in the table two different ways.
>
> Jan 31 1996 12:00AM
> and
> 1/31/1996
>
> -----Original Message-----
> From: Philip Arnold [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 12, 2003 9:22 AM
> To: CF-Talk
> Subject: RE: SQL date conversion issue
>
>
> It looks like the value in the field isn't a valid "date"
>
> Are any of the entries NULL? That can cause problems too for
> conversions like this
>
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
