That is even better, Rals. Thanks

Maybe for you Bhushan,

But until now (630) the incorrects answers (332 = 53%) are still the majority

Thanks Hugo,

Now it's clear to me.

Now the answer is NEVER.

Without the RTRIM then the ansewer : IF NULL is right.

It surprished me a bit when I use this code :

DECLARE @anyDateTime date = null

IF (COALESCE(@anyDateTime,''))...

Thanks to all who have the courage to answer this question before tomorrow.

At this moment the incorrect answers are still the majority.

Yes, 2 points, I am not the one how decides that.

But the statements are important enough

Just on the edge

Hello BWFC,

But now you got a point 🙂

But in your QOTD the dreaded red dot with cross appears... :pinch:

Until now there are more incorrect then correct answers.

Especially the ADD with the keyword COLUMN is a favorit incorrect answer.

That is the reason why I posted this question, it suprised...

Thanks NBSteve, that is how one should explain this.

Why is the type char(3) ?

If I use one of the below selects, then it is all the same !

select convert (char(3),11/9)

select convert (int,11/9)

select convert(float ,11/9)

Interesting. Thanks

I didn't know that.

Thanks. Learned again something !

Nice to know

This question is like kicking of an open door.