/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 vote302 views1 answer
Mysql select all and rename one
SQL
-2 votes316 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote330 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote290 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
4 votes301 views4 answers
Oracle tablespace tables list
SQL
1 vote319 views1 answer
Postgresql substring last
SQL
0 vote311 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
6 votes296 views2 answers
Where clause in sql
SQL
0 vote319 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote288 views1 answer
Automatically update database last seen datetime in sql
SQL