How to extract the first word of a string in SQL?

Question

April 26, 2017SQL SQL Serversql SQL Server

0

Posted

score 0 · Answer 1 · 2015-03-14T12:04:36+00:00

Try this,

select substr (full_name, 1, instr (full_name || ‘ ‘, ‘ ‘, 1, 2) – 1)
from dual;

score 0 · Answer 2 · 2017-03-25T12:48:21+00:00

We can use a UDF for that which takes the text and delimiter as input parameters and returns the first word.

CREATE FUNCTION GetFirstWord
(
@text varchar(2000),@delimiter char(1)
)
RETURNS varchar(2000)
AS
BEGIN

Declare @firstWord varchar(200)
set @firstWord= SUBSTRING(@text,1,(charindex(@delimiter,@text+@delimiter)-1))
return @firstword

END
GO