Database

<br />
SET ANSI_NULLS ON<br />
GO<br />
SET QUOTED_IDENTIFIER ON<br />
GO<br />
CREATE FUNCTION RemoveNonNumerics <br />
(<br />
	-- Add the parameters for the function here<br />
	@sInputValue varchar(24)<br />
)<br />
RETURNS varchar(24)<br />
AS<br />
BEGIN<br />
	-- Declare the return variable here<br />
	DECLARE @Result varchar(24)<br />
<br />
	-- Add the T-SQL statements to compute the return value here<br />
	SELECT @Result = @sInputValue<br />
<br />
	-- Remove non-numeric characters<br />
	declare @i INT<br />
	select @i = 25<br />
	while @i > 0<br />
	begin<br />
		SELECT @i = patindex('%[^0-9]%',@Result)<br />
		SELECT @Result = replace(@Result,substring(@Result,@i,1),'')<br />
	end<br />
<br />
	-- Return the result of the function<br />
	RETURN @Result<br />
<br />
END<br />
GO<br />

DateAdd(15, mi, @date)

SELECT Col1, Col2, Col3
FROM TABLE1 WHERE
Col4 >= ANY
( SELECT Col1 FROM TABLE2 WHERE DateAdded >= '21-Oct-2006')