DNN Expert posted on March 12, 2010 08:31
PROCEDURE GIBS_SEO_Content nvarchar(50) = null
AS
BEGIN
if
(len(@city)=0)
begin
set
@city=null
end
SET NOCOUNT ON;
SELECT City, Village , REPLACE (City,' ','-') + '/' + REPLACE (Village,' ','-') AS EncodeVillageFROM Town_to_VillageWHERE (Village = coalesce(@City,'Harwich') )
END
GO
SET
ANSI_NULLS OFF
GO
SET
QUOTED_IDENTIFIER OFF
GO
@City
CREATE