Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
/****** 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
Join the community of 500,000 technology professionals and ask your questions.