Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About
SQL

Get the First and Last Word from a String or Sentence in SQL

- 11.06.18 | 20.05.22 - ErcanOPAK

You can use the query below:

DECLARE @Sentence VARCHAR(MAX) = 'The quick brown fox jumps over the lazy dog' 

DECLARE @first_space_index int = CHARINDEX(' ', @Sentence) - 1
DECLARE @last_space_index int = CHARINDEX(' ', REVERSE(@Sentence)) - 1

IF @first_space_index < 0
	SELECT @Sentence AS [First Word], @Sentence AS [Last Word] 
ELSE
	SELECT SUBSTRING(@Sentence, 1, @first_space_index) AS [First Word], REVERSE(SUBSTRING(REVERSE(@Sentence), 1, @last_space_index)) AS [Last Word]

First Word   Last Word
------------ -----------
The          dog


If @Sentence = 'The' then the result will be:

First Word   Last Word
------------ -----------
The          The

Related posts:

Create, Alter, Drop and Execute SQL Server Stored Procedures
Average of all values in a column that are not zero in SQL
How to create Local and Global Temp Tables in MS SQL
How to concatenate text from multiple rows into a single text string in SQL server?
Post Views: 665

Post navigation

Add Constraint to SQL Table to ensure email contains @
Get the User Name and Domain Name from an Email Address in SQL

2 thoughts on “Get the First and Last Word from a String or Sentence in SQL”

  1. Daniel says:
    17.05.22 at 12:27

    Fails if only 1 word

    Reply
    1. ErcanOPAK says:
      20.05.22 at 11:50

      Thanks for the feedback, Daniel. I have updated the solution. 🙂

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

September 2023
M T W T F S S
 123
45678910
11121314151617
18192021222324
252627282930  
« Aug    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (665)
  • Get the User Name and Domain Name from an Email Address in SQL (657)
  • How to select distinct rows in a datatable in C# (510)
  • Add Constraint to SQL Table to ensure email contains @ (428)
  • Average of all values in a column that are not zero in SQL (348)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (328)
  • Find numbers with more than two decimal places in SQL (306)
  • Confirm before process with ASPxButton in Devexpress (304)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (277)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (275)

Recent Posts

  • How to remove all non alphanumeric characters from a string in C#
  • How to get the Xth Day of the Week of the Year in C#
  • How to get formatted JSON in C#
  • How to convert JSON to XML or XML to JSON in C#
  • How to use OUTPUT for Insert, Update and Delete in SQL
  • How to get the first and last date of the current year in SQL
  • How to solve extra blank page at end of Microsoft Reportviewer
  • How to Use Picture-in-Picture in Chrome Browser
  • How to add some content to the right side of CardHeader on Bootstrap
  • How to change star rating color on mouseover/out, mouseenter/leave with Javascript

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (665)
  • Get the User Name and Domain Name from an Email Address in SQL (657)
  • How to select distinct rows in a datatable in C# (510)
  • Add Constraint to SQL Table to ensure email contains @ (428)
  • Average of all values in a column that are not zero in SQL (348)

Recent Posts

  • How to remove all non alphanumeric characters from a string in C#
  • How to get the Xth Day of the Week of the Year in C#
  • How to get formatted JSON in C#
  • How to convert JSON to XML or XML to JSON in C#
  • How to use OUTPUT for Insert, Update and Delete in SQL

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

© 2023 ErcanOPAK.com

Proudly powered by WordPress | Theme: Xblog Plus by wpthemespace.com