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)

...

Good explanation, I never had this kind of problem.

Good explanation, I never had this kind of problem.