How to use Parsename in-built function to split delimited data?

Posted by Vishalneeraj-24503 on 3/1/2015 | Category: Sql Server Interview questions | Views: 1164 | Points: 40

Answer:

Use below query:-

select parsename(replace(isnull('vishal kumar',''),' ','.'),1);

Output:
kumar

select parsename(replace(isnull('vishal kumar',''),' ','.'),2);

Output:
vishal

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Response.Redirect method returns which status code ...

Next > : How can we execute a DOS command from Sql Server?

More Interview Questions by Vishalneeraj-24503

Latest Interview Questions