convert rtf to plain text

[tinique]

can anybody please tell me how to use below sql function.I have a
requirement to convert rtf formatted string as plain text from sql
table.I found below sql function in google search. but I dont know how
to use this.what is 'RICHTEXT.RichtextCtrl' ?

CREATE function dbo.RTF2Text(@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 S
-- QL 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

How can I run in the SQL server? Need to download RICHTEXT.RichtextCtrl
activeX?? THANKS!

 

[Sylvain Lafontaine]

The 'RICHTEXT.RichtextCtrl' ActiveX control might be the Microsoft Rich
Textbox Control 6.0 (from VB6) that you can download from the following
page:

http://www.mediamonkey.com/wiki/index.php/Scripting_Resources

or:
http://activex.microsoft.com/controls/vb6/RICHTX32.CAB

You might have some permission issue running this from SQL-Server, I don't
know.