Hi All.
How to create query to remove extra spaces between words in the fields table. I tried like that:
and
How to create query to remove extra spaces between words in the fields table. I tried like that:
Code:
SELECT
LName = TRIM(replace(replace(replace(LName,' ','<>'),'><',''),'<>',' ')),
FName = TRIM(replace(replace(replace(FName,' ','<>'),'><',''),'<>',' ')),
MName = TRIM(replace(replace(replace(MName,' ','<>'),'><',''),'<>',' ')),
Address = TRIM(replace(replace(replace(Address,' ','<>'),'><',''),'<>',' '))
FROM Table1];
Code:
SELECT
LName = TRIM(Replace(Replace(LName, ' ', ' '), ' ', ' ')),
FName = TRIM(Replace(Replace(FName, ' ', ' '), ' ', ' ')),
MName = TRIM(Replace(Replace(MName, ' ', ' '), ' ', ' ')),
Address = TRIM(Replace(Replace(Address, ' ', ' '), ' ', ' '))
FROM Table1;[CODE]
Unfortunately it doesn't work.