Jim,

>Here’s another one... I have two tables, one has a name Foreign Key, the other the names. I would like to create a third table via SQL SELECT that would have a field “Full Name” that would have the combined fields FirstName and LastName looking something like LastName, Firstname. Is this something I can do somewhat easily in SQL?

SELECT PADR(TRIM(lastname)+", "+firstname,40) AS FullName ...