SQL Server, Remove Extra Spaces from nvarchar

Asked Oct 21 '15 at 07:35

Active Oct 21 '15 at 07:41

Viewed 40 times

I have a table column 'Name' in SQL Server 2012 which contains data in a form such as:

'  first      name  '

What I want is to remove while select, the extra spaces (multiple spaces in between with only one space) and the result should be like:

'first name'

Any help? Thanks

edited Oct 21 '15 at 07:41

Tim Biegeleisen

asked Oct 21 '15 at 07:35

Ikram Khan

create UDF break words on space,reject row with empty word,finally append row with text and space – Shekhar Pankaj Oct 21 '15 at 07:40
SQL Server does not support regex out of the box, so this is a hairy question. – Tim Biegeleisen Oct 21 '15 at 07:42
The dupe + `ltrim` and `rtrim`. – Martin Smith Oct 21 '15 at 07:43
you can do this " select substr(ltrim(xyz),1,index( ltrim(xyz) ,' ') ) as firstname, trim(substr(ltrim(xyz),index( ltrim(xyz),' '))) as lastname, firstname||' '||lastname as final_data from space " just replcae the index function with SQL server equivalent. – anwaar_hell Oct 21 '15 at 08:20

0 Answers0