How to Remove Space with dash (-) in SQL Server

In this article, we learn how to replace space with the dash in SQL Server. As we know that space (white space) is a character and dash is also a character.Many developers read about the replace query or replace function in SQL server when if someone asked about How to Remove Space with the dash (-) in SQL Server then he thinks so much so this article will help you.

Table (info_table)

For All Columns

Query:-

update info_table

set address = replace(address, ' ', '-')

Out-Put:-

Selected Columns

update info_table

set address = replace(address, ' ', '-') where uid=1

Out-Put