var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: seperating names
I have a field that lists names in the following format:
lastname, firstname middleinitial
smith, bob f
Sometimes there is no middle initial sometimes there is. I'd like to make a "make table query" that would seperate these somehow. Does anyone know how to accomplish this?
Use a select query to extract the names and initials.
This will extract the first name/s and initials.
This will extract the surname.
Run your make table query from this.
Is there a way to pull out that middle initital? Sometimes the data has a middle initial sometimes it doesn't. I'm not sure if this poses any kind of problem.