Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
/****** Object: UserDefinedFunction [dbo].[ufn_Utility_GetWord] Script Date: 03/11/2011 08:50:18 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[ufn_Utility_GetWord] (@value varchar(max), @WordCount as int, @Delimiter as varchar(3)) RETURNS varchar(max) AS BEGIN RETURN CASE CHARINDEX(' ', @value, 1) WHEN 0 THEN @value ELSE reverse(SUBSTRING(reverse(@value), 1, CHARINDEX(' ', reverse(@value), 1) -1)) END END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.