Do Real Values sort different than floats in SQL Server queries? -


Can someone think of a reason to do this:

SELECT * FROM TableA ORDER cast (cast (as nvarchar (50)) as the real column column - where realColumnA is defined as in the table

One of my former developers stressed that the reality It was necessary to sort correctly, can any one think of a reason that can be true?

Cast is a big demonstration killer in the order section. But I need to make sure that before I can remove it before necessary.

It is done by the order extract what you expect. And it will definitely be a demonstration killer.

Rules # 1 Questions about SQL (and test) your all (and others) beliefs. (Especially strange people like this.)


Comments