convert rtf to plain text

  • Thread starter Thread starter tinique
  • Start date Start date
T

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!
 
Back
Top