Please Ignore the following message:


>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?