sp_configure 'clr_enable', 1 GO RECONFIGURE GO EXEC sp_dbcmptlevel {0}, 90; GO IF EXISTS (SELECT * FROM sys.objects WHERE [object_id] = OBJECT_ID(N'[dbo].[AmountToLetters]') AND [type] = 'FS') DROP FUNCTION [dbo].[AmountToLetters] GO IF EXISTS (SELECT * FROM sys.assemblies WHERE [name] = N'sqludf') DROP ASSEMBLY [sqludf] GO CREATE ASSEMBLY sqludf FROM '{1}' GO CREATE FUNCTION AmountToLetters(@number FLOAT, @lang NVARCHAR(5) = 'en-US') RETURNS NVARCHAR(255) AS EXTERNAL NAME [sqludf].[Octopus.Description.Number.UDF].[AmountToLetters] GO