Hi All.
How to create query to remove extra spaces between words in the fields table. I tried like that:
SELECT
LName = TRIM(replace(replace(replace(LName,' ','<>'),'><',''),'<>',' ')),
FName = TRIM(replace(replace(replace(FName,' ','<>'),'><',''),'<>',' ')),
MName =...