0

I try to copy the column value from query results into the SQL Server Management Studio Query window.

The column value displays a value like this: Caserí-o La Dehesilla However, the - character is not a regular hyphen character it seems, because when I copy the value, I see this pasted: Caserío La Dehesilla. If I paste the value in Notepad++ it does work correctly. How can I make sure I can paste this - character in the query window?

ps. it's not the font as suggested here.

Community
  • 1
  • 1
Adam
  • 6,041
  • 36
  • 120
  • 208
  • 1
    It looks like SSMS has problem with **soft hypen** (SHY/unicode ad) character. [Demo](https://data.stackexchange.com/stackoverflow/query/396270) – Lukasz Szozda Nov 21 '15 at 15:12
  • Hmmm...thanks. I need to run a query that replaces this soft hyphen with a regular hyphen...how can I do that now? – Adam Nov 21 '15 at 15:36
  • 1
    Simple `REPLACE` do the job [demo](https://data.stackexchange.com/stackoverflow/query/396294) `UPDATE #tab SET val = REPLACE(val, NCHAR(173), '');` – Lukasz Szozda Nov 21 '15 at 15:42

0 Answers0