/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 vote135 views1 answer
Postgres sql alter table delete row
SQL
0 vote117 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote136 views1 answer
Sql track modification
SQL
0 vote143 views1 answer
Redshift running queries
SQL
2 votes129 views4 answers
Check timezone of mysql database
SQL
0 vote130 views1 answer
Why mysql is used?
SQL
12 votes199 views4 answers
How to drop all tables in postgresql
SQL
10 votes81 views1 answer
Oracle view dependencies
SQL
0 vote189 views1 answer
How to add auto increment primary key
SQL
1 vote127 views1 answer
Sql first
SQL