title: RTF to TEXT in sql server
body: <p>I have a RTF field in my SQL 2005 table, I need to convert it to Text and display it. 
  After a quick research I got the following method...</p>
  
  <pre><code>create function dbo.RTF2TXT(@in varchar(8000)) RETURNS  varchar(8000) AS 
  BEGIN
  
  DECLARE @object int
  DECLARE @hr int
  DECLARE @out varchar(8000)
  
  -- Create an object that points to the SQL Server
  EXEC @hr = sp_OACreate 'RICHTEXT.RichtextCtrl', @object OUT
  EXEC @hr = sp_OASetProperty @object, 'TextRTF', @in
  EXEC @hr = sp_OAGetProperty @object, 'Text', @out OUT
  EXEC @hr = sp_OADestroy @object
  return @out
  
  END
  GO
  
  select dbo.RTF2TXT('{\rtf1\ansi\ansicpg1252\uc1 aaa}')
  </code></pre>
  
  <p>But Here I am getting only NULL as result...
  What could be the issue, please suggest</p>