Hello. I need help with something and maybe someone can help me out. I'll try and explain. I have a field called first_name that contain the person first name in that field. The field is 15 character in length.
first_name: John D
I am doing a data extraction that I only want JOHN and not the D. How would I go about doing that?
Another question as well. I have a field that is an address field. In that field, if the first letter is an "N", I would like to perform a statement to clear the address field to spaces. The address field is 20 character in length.