You could simply perform an update on all the records like this:
UPDATE MyTable
SET cityarea_name = LTRIM(cityarea_name)
There's no reason to narrow down the scope of the update because you will probably slow down the update if you try to do something like this:
UPDATE MyTable
SET cityarea_name = LTRIM(cityarea_name)
WHERE LEFT(cityarea_name, 1) = ' '