Distinct problem

Hello!
I need some help with this DISTINCT problem. What am I doing wrong?
My T-SQL is lousy, I know...
SELECT DISTINCT (Deliver) FROM (SELECT Deliver=CASE
WHEN DelivDate >'2006-12-31' THEN '1999-12-31'
ELSE DelivDate
END
FROM TTransaction)
Result:
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near ')'.
Regards
ClarkieTry this
SELECT DISTINCT (Deliver) FROM (SELECT Deliver=CASE
WHEN DelivDate >'2006-12-31' THEN '1999-12-31'
ELSE DelivDate
END
FROM TTransaction) Deliver|||Works like a charm!
Tack s mycket!
//Clarkie
"Patrik" <corneliusson@.gmail.com> wrote in message
news:1138615960.416301.25580@.o13g2000cwo.googlegroups.com...
> Try this
> SELECT DISTINCT (Deliver) FROM (SELECT Deliver=CASE
> WHEN DelivDate >'2006-12-31' THEN '1999-12-31'
> ELSE DelivDate
> END
> FROM TTransaction) Deliver
>