Remove spaces from field value

Question

I am trying to create a function that removes all the spaces (single or multiple) in a field anywhere in the column. For Example, if a tag = [B00 -PCV 6143-C-], it would get changed to [B00-PCV6143-C-].

Any help would be appreciated.

Gordon Linoff · Accepted Answer · 2015-03-22 19:24:49Z

4

Use replace():

select replace(tag, ' ', '') as TagWithNoSpaces

answered Mar 22, 2015 at 19:24

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Samay · Accepted Answer · 2015-03-30 07:35:57Z

0

You can use REPLACE()

SELECT REPLACE('[B00 -PCV 6143-C-]',' ','')

REPLACE() - MSDN

edited Mar 30, 2015 at 7:35

answered Mar 23, 2015 at 11:16

Samay

5037 silver badges14 bronze badges

Collectives™ on Stack Overflow

Remove spaces from field value

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related