/SQL/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]

Source: sql-server-helper.com

Similar codes

0 vote236 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote238 views1 answer
How to change null display in psql
SQL
3 votes244 views2 answers
Df to sql pandas sql achemy
SQL
0 vote267 views1 answer
Psql initialization
SQL
12 votes231 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote206 views2 answers
Sql update from two different database
SQL
0 vote230 views1 answer
Oracle exchange subpartition
SQL
0 vote236 views1 answer
Codigo crear tablas sql server
SQL
0 vote224 views1 answer
Mysql query single row
SQL
0 vote236 views1 answer
Modificar tipo de dato sql server
SQL