• This one was a pretty hard one.

    I never heard of "Collate" and I was converting "Collate" with "collation" wich mean "small lunch" in french... but I don't think that SQLserver needs to lunch any time :laugh: so I had to search for what it means before, then find the microsoft site... then tried to understand it... then ... well, you know...I lost patience and answered the only one that looked logic to me, wich was wright, but not enough.

    Finally, now that I have read the answer, I just realised that I loosed my patience only one paragraph before the answer!! Well... yup! I deserved loosing that point !

    Thank you for the nice question. I learned two things today: the failing of a collate command and never loose patience 🙂