I feel like one of the only holdouts nowadays. I've lost count of the number of times I've had to do...

To answer your question, you can get the first substring after the comma by doing something like this:

CASE WHEN CHARINDEX(' ',full_name,CHARINDEX(',',full_name)+1) > 0

THEN LTRIM(SUBSTRING(full_name,CHARINDEX(',',full_name)+1,CHARINDEX(' ',full_name,CHARINDEX(',',full_name)+1)))

ELSE RIGHT(full_name,DATALENGTH(full_name)-CHARINDEX(',',full_name))

END

This uses the third (optional)...

Can you please provide the results you expect based on that sample data?

Heh, cool deal. So, I must be missing something here (and the lack of code blocks totally hoses my display so the code is hard to follow, but what...

How about this?

http://www.sqlservercentral.com/articles/SQLCLR/68842/

Also, could you wrap that really long line in a code block so that it doesn't hose the formatting of the page?

SSMS doesn't show line breaks. In reality, they probably don't serve a lot of purpose in that script, I just did it out of habit.

I can't get the term 'That guy' out of my head right now. I think you'd probably find a warning against this in chapter one of 'Beginning Database Administration...

Yeah, I think I should have googled first, asked the question afterwards. The database is restoring fine on another 2008 server, and a quick google informs me that the...

This could potentially be a massive time saver for me. Thanks so much for writing this article and sharing this code.

I think it depends on how much you have to deal with permissions. In most of my environments, permissions have been either 'all' or 'nothing' on the database itself,...

Edited out the example of said evil. I don't think it is commonly known and I don't want to help it become so.

Man, I've used that script 2 times in 2 days! Look out Lowell, I'm creepin into your territory! :hehe:

SSMS can be picky on what it displays. However, just because it is not displaying it doesn't mean that something else pulling the data will not. If you...

What application is doing the display? QA? SSMS? Crystal? Something else?

Hrm, and now that I think about it, if I am right, I'm gonna go edit that back out of my post, don't want to give anyone any ideas :-D.