I finally got my code to work and the output to look like I wanted.

---code snipet---

SELECT RTRIM(SUBSTRING(Full_Name, CHARINDEX(' ', Full_Name, 1) + 1, DATALENGTH(Full_Name))) + ',' + ' '...

One thing I forgot to mention was I am runing this on SQL Server 2005. Could this be the problem. Should I repost this to the other SQL...

---- Create table to test name conversion ----

CREATE TABLE [dbo].[A_table](

[FUll_Name] [char](40) NULL

) ON [PRIMARY]

---- Insert data into table ----

INSERT INTO A_table (Full_Name)

SELECT 'John Smith' UNION ALL

SELECT 'Jeff Moden'...

When I try your code example it works, when I apply the code to data in an existing table I get blank spaces and then a comma and then first...

Good stuff Thanks everyone!:D

Thanks for all suggestions.  Turns out it was a hardware related issue.  The HBA was having problems connecting to the SAN.  We tried to reboot the server and it would...

Where would you check the following? 

"Is the user's login set for Windows Authentication or SQL Server Authentication?

Is the group set for Windows or SQL Server authentication?"

I thought all Windows groups use...

Turns out the Startup Parameter -T3608 was never removed after we moved the master and Model database locations.

Sounds like a great product, I'm looking forward to testing it out on our servers.  The sales rep I spoke with at the SQL Server 2005 roadshow says it won't...

I ended up changing the field types from text to varchar. After the change the problem cleared up.  I see this as work around and not a solution.  I am running...

All sources are SQL Server

I ran sp_refreshview and the problem is still present. The view works fine. When do a select statement on it returns the expected data. It's only inside the...

This whole thing seems like a big money making raquet for a select industry.  Companies like Price Waterhouse Cooper are making money hand over fist charging companies to do audits.  This whole...