/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

7 votes172 views4 answers
What is my mysql version
SQL
0 vote233 views1 answer
Convert rows into columns in oracle
SQL
1 vote207 views2 answers
Copy table in sql
SQL
1 vote175 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote211 views1 answer
Plsql check for string in numeric
SQL
1 vote202 views1 answer
Epoch time converter in snowflake
SQL
2 votes171 views3 answers
Mysql pass command from command line
SQL
0 vote181 views1 answer
How to create a new shema using query languaage
SQL
0 vote191 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
5 votes131 views1 answer
Mongodb vs
SQL