question

Hello , This is my scalar function!! SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [BUSINESS_DURATION_MINTS_FN] (@string varchar(100) ) RETURNS INT AS BEGIN DECLARE @total_mints INT DECLARE @hours INT DECLARE @Mints INT IF @string IS NOT NULL BEGIN SET @string = REPLACE(UPPER(@string),'HOURS','HOUR') SET @string = REPLACE(UPPER(@string),'MINUTES','MINUTE') IF ((CHARINDEX(UPPER('HOUR'),UPPER(@string))!=0) AND (CHARINDEX(UPPER('MINUTE'),UPPER(@string))!= 0)) BEGIN SET @hours = CONVERT(INT,SUBSTRING(@string,1, (CHARINDEX(UPPER('HOUR'), UPPER(@string))-2))) SET @Mints = CONVERT(INT,SUBSTRING(@string,(CHARINDEX(UPPER('HOUR'),UPPER(@string))+4),(CHARINDEX(UPPER('MINUTE'),UPPER(@string))-(CHARINDEX(UPPER('HOUR'), UPPER(@string))+5)))) END IF ((CHARINDEX(UPPER('HOUR'),UPPER(@string))=0) AND (CHARINDEX(UPPER('MINUTE'),UPPER(@string))!= 0)) BEGIN SET @hours = 0 SET @Mints = CONVERT(INT,SUBSTRING(@string,1, (CHARINDEX(UPPER('MINUTE'), UPPER(@string))-2))) END IF ((CHARINDEX(UPPER('HOUR'),UPPER(@string))!=0) AND (CHARINDEX(UPPER('MINUTE'),UPPER(@string))=0)) BEGIN SET @hours = CONVERT(INT,SUBSTRING(@string,1, (CHARINDEX(UPPER('HOUR'), UPPER(@string))-2))) SET @Mints = 0 END IF ((CHARINDEX(UPPER('HOUR'),UPPER(@string))= 0) AND (CHARINDEX(UPPER('MINUTE'),UPPER(@string))=0)) BEGIN SET @hours = 0 SET @Mints = 0 END SET @total_mints = @hours*60 + @Mints END IF @string IS NULL BEGIN SET @total_mints = NULL END RETURN @total_mints END GO How do I call this function in a stored procedure?? Can you help me with any code??? Thanks!!