Answers for "Get the First and Last Word from a String or Sentence"

Get the First and Last Word from a String or Sentence

DECLARE @Sentence    VARCHAR(MAX) = 'The quick brown fox jumps over the lazy dog'

SELECT SUBSTRING(@Sentence, 1, CHARINDEX(' ', @Sentence) - 1) AS [First Word],
       REVERSE(SUBSTRING(REVERSE(@Sentence), 1,                CHARINDEX(' ', REVERSE(@Sentence)) - 1)) AS [Last Word]

Posted by: Guest on April-30-2021

Code answers related to "Get the First and Last Word from a String or Sentence"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "Get the First and Last Word from a String or Sentence"

Code answers related to "Get the First and Last Word from a String or Sentence"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "Get the First and Last Word from a String or Sentence"

Code answers related to "Get the First and Last Word from a String or Sentence"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us