/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

1 vote151 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote163 views1 answer
Time in sql server
SQL
0 vote136 views1 answer
Sql server bool select
SQL
1 vote139 views1 answer
Psql connections
SQL
1 vote140 views1 answer
Grab all records from one table to another oracle sql
SQL
1 vote152 views1 answer
Join to find results not in another table
SQL
3 votes135 views1 answer
Postgres update column with value from another table
SQL
7 votes131 views6 answers
Reset identity column in sql server
SQL
0 vote137 views1 answer
Mysql count grouped rows
SQL
0 vote134 views1 answer
Mysql cdn link
SQL