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
How to Remove Space with dash (-) in SQL Server
Reviewed by NEERAJ SRIVASTAVA
on
10:00:00 PM
Rating:
![How to Remove Space with dash (-) in SQL Server](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9imqsVrJPmNgtWBUCZNlLckKMi6_eMZWpfdOlKT4BL0dYNo4sCCVdK0cnrQ6ho1ho4Z-gQtEJpE5mfNJYA3WmTI3RRAh8W57Ld6joBxkP9xd7151vk2YAhygDp4f8sY5jWShrteKcJOM/s72-c/remove+space+dash+board.png)
No comments: