Fedor 28151 (10/23/2015)

---

I prefer notation, described in post.

If state of record considered as normal, it should be "0". I use value "1" for special condition.

For example:

Correct:

Default state of...

Good question.

So, what's the correct way to do the conversion?

DECLARE @REAL REAL= 43.39061;

SELECT @REAL

SELECT CONVERT(FLOAT, @REAL)

SELECT CAST(@REAL AS FLOAT)

Good explanation, I never had this kind of problem.

Good explanation, I never had this kind of problem.