title: Is there an SQL Server equivalent for C# double.Epsilon and float.Epsilon ?
body: <p>Does <code>SQL Server</code> define epsilon constants for <code>float</code> and <code>real</code> types ?
  In other words,  a value which is small enough to be considered as insignificant ? </p>
  
  <p>in C#, there are <code>double.Epsilon</code> and <code>float.Epsilon</code> constants for that.
  Unfortunately, they are too small to be used in SQL Server (which AFAIK consider them as equal to 0).</p>
  
  <pre><code>//C#
  public struct Single
  {
      public const float Epsilon = (float)1.4e-45;
  }
  
  public struct Double
  {
      public const double Epsilon  = 4.9406564584124654E-324;
  }
  
  //SQL Server
  select CAST('4.9406564584124654e-324' AS float) //returns 0
  select CAST('1.4e-45' AS real) //returns 0
  </code></pre>