I have a parameter in which I need to pass a code that contains an "&"
(ie.  'TI & GT').   What is the syntax for me to correctly do this?   I
have tried 'TI & GT' and 'TI &amp GT' as parameters but get no rows
returned.

Thanks

*** Sent via Developersdex http://www.developersdex.com ***

Top 100 ... Order by in views SQL 2005 problem
SQL 2005: Why does DECLARE varchar(MAX) in Stored Procedure not work?
cumulative problem
Passing parameter from a recordset in a Stored Procedure
Help with Subquery and "Group By"