Recent content by ncstateguy

Ok, I am trying something along these lines: SET last_name = substr(teachername,1,instr(teachername, ',') -1) What does access use instead of the Substring command to do this procedure?

Thanks, I am somewhat familiar with the Left and Right commands. I am cautious to just try it. I have a database of 980,000 entries with several fields. I just dont want to screw up my data or wait to make a new copy of this db each time I guess and mess up. I am not sure how to use the...

I have a field called name format is: Lastname, FirstName Middlename I want to separate these three pieces of data into columns: Last Name First Name Middle Initial Notice I only want the first letter of the middlename. How should I go about doing this. I'm...