Concatenating Name field

[Anon]

I know I did this before, but I cant remember how to do it. I have an address book with the name field designed all as one name, like: Name = Sanders, Brett. I am trying to print address labels and want the name to print out Brett Sanders.
Does anyone know how to do this.

[Anon]

so
$name = "Sanders, Brett";
$strNameTok = explode(",", $name);
$strNewName = trim($strNameTok[1])." ".trim($strNameTok[0]);

$strNewName == "Brett Sanders";

hth.
p.

[Anon]

This is in an access database

[reagent]

what does that have to do w/ that php code? Or was that question nothing to do w/ php...

[Anon]

I guess I am in the wrong place I am not sure what PHP is. Do you know any access

[harlan]

the truth of the matter is that you should have broken up the table into two columns.

first_name and second_name.

This is a basic part of the technique of normalizing databases. Since it's a database that speaks SQL, extracting out the two names and arranging them any way you like. This way, you're stuck on your data model.

I suggest books like "SQL for Smarties", "mySQL and mSQL" or the SQL tutorial on arsdigita.com. They are all good resources for learning SQL, normalization, and database theory in general