Extract the first word of a string in a SQL Server query

by 
SELECT CASE CHARINDEX(' ', @Foo, 1)
     WHEN 0 THEN @Foo -- empty or single word
     ELSE SUBSTRING(@Foo, 1, CHARINDEX(' ', @Foo, 1) - 1) -- multi-word
END

You could perhaps use this in a UDF:

CREATE FUNCTION [dbo].[FirstWord] (@value varchar(max))
RETURNS varchar(max)
AS
BEGIN
    RETURN CASE CHARINDEX(' ', @value, 1)
        WHEN 0 THEN @value
        ELSE SUBSTRING(@value, 1, CHARINDEX(' ', @value, 1) - 1) END
END
GO -- test:
SELECT dbo.FirstWord(NULL)
SELECT dbo.FirstWord('')
SELECT dbo.FirstWord('abc')
SELECT dbo.FirstWord('abc def')
SELECT dbo.FirstWord('abc def ghi')

More Related Contents:

  1. SQl CASE Statement
  2. Levenshtein distance in T-SQL
  3. How to get sp_executesql result into a variable?
  4. How can I use optional parameters in a T-SQL stored procedure?
  5. Select query to remove non-numeric characters
  6. T-SQL Decimal Division Accuracy
  7. Selecting a Record With MAX Value
  8. T-SQL Pivot? Possibility of creating table columns from row values
  9. What is a “batch”, and why is GO used?
  10. TSQL divide by zero encountered despite no columns containing 0
  11. T-SQL loop over query results
  12. How to insert default values in SQL table?
  13. How to Round a Time in T-SQL
  14. How to convert a “dd/mm/yyyy” string to datetime in SQL Server?
  15. t-sql get all dates between 2 dates [duplicate]
  16. Return a value if no rows are found in Microsoft tSQL
  17. How to pivot table with T-SQL?
  18. Using Aliases in Where Clause or an Alternative Option?
  19. Testing for inequality in T-SQL
  20. Can I use the MERGE statement in SQL Server 2005?
  21. Replace a newline in TSQL
  22. Search for one value in any column of any table inside a database
  23. How to use an Alias in a Calculation for Another Field
  24. Check if a varchar is a number (T-SQL)
  25. Using a cursor with dynamic SQL in a stored procedure
  26. Truncate Datetime to Second (Remove Milliseconds) in T-SQL
  27. Convert unix epoch timestamp to TSQL datetime
  28. Poor Man’s SQL Pivot. List Questions as Columns and Answers per User in one row
  29. String.Format like functionality in T-SQL?
  30. How to parse string into date?

Leave a Comment