/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 vote259 views1 answer
Migrations.RunSQL
SQL
0 vote233 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote187 views1 answer
How to fetch unique records from two tables
SQL
0 vote197 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
12 votes167 views5 answers
Sql merge
SQL
4 votes186 views1 answer
Oracle delete last row
SQL
2 votes185 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
49 votes262 views6 answers
Alter table add column
SQL
10 votes175 views4 answers
Join with multiple conditions sql
SQL
15 votes279 views4 answers
Mysql export database command line
SQL