I have a column in a table that contains a full name value like this: Foster, Lorenzo E I would like to take all the values from this column...

There isn't a simple explaination for this. However, I'll try my best: I don't know if I understand anymore about your problem other than the fact you must split the name. Here's How I would do it: 1. To get the last name, I would use CHARINDEX to locate the position of the comma. Then using LEFT, you can scrape the last name out. 2. To get the first name, I would use SUBSTRING and use 1 + the position of the comma, and -2 the LEN of the string. 3. Finally the midde initial. I would simply use the RIGHT function. SQL Server makes it pretty easy with all the wonderful funtions. To see how to use these functions, launch SQL Server Books Online (not the internet) and look up String Functions (T-SQL) in the index. Hope this helps! Regards, Matthew Pomar

Woops, I think I might have read your questions wrong. Here's how I would do it: Select [FirstName] + " " + [LastName] As FullName From Members I've tested this and it works. Regards, Matthew Pomar