Removing a space from the beginning

[rickyzicky]

I have made changes using the find/replace fucntion.
I removed the word "the" from all fields and replace it with nothing. This left a space at the beginning of many fields.

I need to remove the space at the beginning of the field without affecting any other in the field.

Thanks

 

[PHV]

You may follow the update query way:
UPDATE yourTable SET yourField=Trim([yourField])
WHERE yourField Like ' *'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[straybullet]

Or since you're already comfortable with the Find n Replace...
Open Find and Replace and put a space into the find text field. Leave the replace blank. Choose Start of field in the Match dropdown. This will remove all starting spaces without affecting the rest.

Let them hate - so long as they fear... Lucius Accius

 

[rickyzicky]

Makes good sense but the update already worked for me.
This is resolved.

Thanks to all.