title: How do I TryParse in SQL 2000?
body: <p>I have a stored procedure in an old SQL 2000 database that takes a comment column that is formatted as a varchar and exports it out as a money object. At the time this table structure was setup, it was assumed this would be the only data going into this field. The current procedure functions simply this this:</p>
  
  <pre><code>SELECT CAST(dbo.member_category_assign.coment AS money)
    FROM dbo.member_category_assign
   WHERE member_id = @intMemberId
         AND 
         dbo.member_category_assign.eff_date &lt;= @dtmEndDate
         AND 
         (
          dbo.member_category_assign.term_date &gt;= @dtmBeginDate
          OR 
          dbo.member_category_assign.term_date Is Null
         )
  </code></pre>
  
  <p>However, data is now being inserted into this column that is not parsable to a money object and is causing the procedure to crash. I am unable to remove the "bad" data (since this is a third party product), but need to update the stored procedure to test for a money parsable entry and return that.</p>
  
  <p>How can I update this procedure so that it will only return the value that is parsable as a money object? Do I create a temporary table and iterate through every item, or is there a more clever way to do this? I'm stuck with legacy SQL 2000 (version 6.0) so using any of the newer functions unfortunately is not available.</p>