title: Comparison with '{0}' in SQL SELECT
body: <p>I have to take over old colleague's code and trying to understand this one SQL statement like below:</p>
  <pre><code>SELECT * FROM my_table WHERE date_key = '{0}'
  </code></pre>
  <p>Column <code>date_key</code>contains <code>int</code> values such as <code>20220712</code>, <code>20220120</code>, etc.</p>
  <p>The first guess is that <code>SELECT</code> statement filters for rows with <code>0</code> value in column <code>date_key</code>. However, when running that line of code, I receive this error :</p>
  <pre><code>SQL Error [100038] [22018]: Numeric value '{0}' is not recognized
  </code></pre>
  <p>What exactly does that line of code do?</p>