Thanks for the response, I bet your correct -- comment

Thank you for pointing me to a solution.

still no luck error: AMP; Load Room' is not valid

LOCATION=Bridge%20&%20Load%20Room

• This reply was modified 1 year, 6 months ago by  lee.hopkins.

I have a hyper link to an ssrs report that is created from a DB call. One of the parameters has an & in it and causing a failure. The...

This might work, Tks

• This reply was modified 3 years, 10 months ago by  lee.hopkins.

found my own solution

SELECT dbo.GetEnglishDate('Portuguese', '01-ago-2014')

CREATE FUNCTION GetEnglishDate

(@language VARCHAR(25), @DateString VARCHAR(30))

RETURNS VARCHAR(30)

AS

Begin

--DECLARE @language VARCHAR(25)

--DECLARE @DateString VARCHAR(30)

DECLARE @langMonths VARCHAR(100)

DECLARE @engMonths VARCHAR(100)

DECLARE @frnMonth VARCHAR(3)

DECLARE @engMonth VARCHAR(3)

--SET @language = 'Portuguese'

--SET @DateString =...