/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 vote76 views0 answer
How to connect to datbase in springboot
SQL
0 vote127 views2 answers
Connect to mysql server mac terminal
SQL
1 vote161 views1 answer
How not to sort by average rating
SQL
0 vote116 views1 answer
Sql server query database space available
SQL
0 vote118 views1 answer
Which MySQL data type to use for storing boolean values
SQL
8 votes115 views1 answer
Oracle search stored procedures for text
SQL
1 vote113 views1 answer
Create temporal table in sql
SQL
0 vote112 views4 answers
Best data type to represent money in mysql
SQL
0 vote115 views1 answer
Psql list view rules
SQL
0 vote126 views1 answer
Returning with sqlalchemy
SQL