removing space from field
This has to be simple but Trim, TrimAll functions does not seem to do what I thinkit should do. I have imported manes into a DB and some of the names have a space as the first character that I want to getrid of. I had thought using field validationa nd the trim/trimall function would do the trick. so far nogo. I am far from a guru (just a learner) so please be patient! Can you suggest what I need to do please to remove the first space in my field "fname".
BTW using FM MAc version 8.x