/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 vote169 views1 answer
Get clob size oracle
SQL
0 vote9.7K views1 answer
Postgresql delete type
SQL
-1 vote166 views1 answer
Mysql #1064 error
SQL
0 vote226 views1 answer
Suhaib
SQL
3 votes204 views1 answer
How to uninstall microsoft sql server
SQL
0 vote166 views2 answers
Mysql update two tables at once
SQL
0 vote178 views1 answer
Sql drop default
SQL
0 vote184 views1 answer
Update sqlite
SQL
0 vote175 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
3 votes170 views3 answers
C# sql select
SQL