Want to know how to remove space among words in sql

Question

I want to know how to remove space between first and second word. But it should not remove other spaces in the same column. (Using SQL) It looks like this,

No. 378, Bearly Road, Colombo.

I want to remove only the space between "No." and "378". After remove it should be like this,

No.378, Bearly Road, Colombo.

Does this answer your question? [Replace first occurrence of substring in a string in SQL](https://stackoverflow.com/questions/38911588/replace-first-occurrence-of-substring-in-a-string-in-sql) — Dale K, Jul 02 '20 at 03:10

chriptus13 · Answer 1 · 2020-07-02T02:33:08.220

0

Try using String::replaceFirst (assuming you're doing this in Java).

str.replaceFirst(" ", "");

For SQL-Server check this.

edited Jul 02 '20 at 02:33

answered Jul 02 '20 at 02:24

chriptus13

705
7
20

1

@DaleK This answer is using Java, possibly because the Java tag appears under the question. It probably assumes that the data came from SQL, but the replacement is wanted for Java. – Tim Biegeleisen Jul 02 '20 at 02:30
*remove only the space between "No." and "378".* - your answer will ignore this requirement – Scary Wombat Jul 02 '20 at 02:36
Any idea doing this using sql?? – Nishan Jul 02 '20 at 02:49
@chriptus13 rather than linking to an existing answer, please vote to close as a duplicate. – Dale K Jul 02 '20 at 03:11

score 0 · Answer 2 · answered Jul 02 '20 at 11:39

0

 SELECT STUFF('No. 1', CHARINDEX(' ', 'No. 1'), 1, '')
                    (or)
SELECT concat(left('No. 1',CHARINDEX(' ','No. 1')-1),substring('No. 1',CHARINDEX(' ','No. 1')+1,len('No. 1')))

answered Jul 02 '20 at 11:39

K Viswagna

99
5

Want to know how to remove space among words in sql

2 Answers2