title: How to update varbinary(max) column with path stored in varchar column?
body: <p>I currently have a varchar(255) column that stores the path to a small image file.  I want to try to load the file into a new column of type varbinary(max), but don't know how to write a stored procedure to do such.  Something like such</p>
  
  <pre><code>UPDATE MyTable
  SET image = "file located in field imagePath"
  </code></pre>
  
  <p>I know that makes no sense because I don't have a where clause, but what would I put in it's place??</p>