I need to be able to run a query that deletes all spaces contained within a field. The table is tblSymbol and has a field symCode.
Field symCode contains a mixtureof alpha characters and spaces. I need to delete all spaces from within the field. lets say I have someting like
G H D
FFD (space) (space) etc
I need to end up with
FFD (with no following spaces) in fact no following spaces for any of the symbols in the field.
need a quick solution here, thanks