>>757
select left(colA, len(replace(colA,' ',' ')))