Getting Second Word in Given Sentence in SQL Server

Hello everyone. In this article, I will try to give information about getting the second word in the sentence given in SQL Server.

In SQL Server you may want to get the second word in the given sentence in some cases.

You can easily do this using the code below.

DECLARE @Cumle NVARCHAR(264);

SET @Cumle = N'Yavuz Selim Kart';

SELECT LTRIM(SUBSTRING(
                          @Cumle,
                          CHARINDEX(' ', @Cumle),
                          CHARINDEX(
                                       ' ',
                                       LTRIM(SUBSTRING(
                                                          @Cumle,
                                                          CHARINDEX(' ', @Cumle),
                                                          LEN(@Cumle) - CHARINDEX(' ', @Cumle)
                                                      )
                                            )
                                   )
                      )
            );

When you run the above code, you will see a result similar to the one below.

As you can see, we have taken the second word in the given sentence.

Good luck to everyone in business and life.