/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 vote204 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote140 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
4 votes161 views2 answers
Oracle unlock account
SQL
18 votes125 views3 answers
Mysql query add column with default string value
SQL
7 votes167 views3 answers
Restore postgres database from sql file
SQL
0 vote137 views1 answer
Number(10 2) in sql means
SQL
1 vote126 views1 answer
Sql auto timestamp
SQL
10 votes141 views4 answers
Else if mysql
SQL
0 vote142 views1 answer
Mysql date only no time
SQL
5 votes148 views1 answer
Oracle ora-00054 resource busy
SQL