Modified function for languages using accented letters (french for example)

CREATE FUNCTION dbo.URLEncode(

@decodedString VARCHAR(4000)

)

RETURNS VARCHAR(4000)

AS

BEGIN

DECLARE @encodedString VARCHAR(4000)

IF @decodedString LIKE '%[^azertyuiopmlkjhgfdsqwxcvbnAZERTYUIOPMLKJHGFDSQWXCVBN0-9*-.!_]%' ESCAPE '!'

BEGIN

...