OK, I have a query in a stored procedure like this:

SELECT *
FROM CITIES
WHERE CITY_NAME LIKE '%' + @playUn + '%'

It works fine, but if i pass a city name with a dash (e.g New-York), it
doesn't return any records. 

In other words if i do a select like:

SELECT *
FROM CITIES
WHERE CITY_NAME LIKE '%New-York%',  doesn't work.  (Table has 'New-York'
records.)

Why is this?