--
PRINT 'Create function fn_IsGUID'
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[fn_IsGUID]') AND xtype IN (N'FN', N'IF', N'TF'))
	DROP FUNCTION dbo.fn_IsGUID
GO

CREATE FUNCTION dbo.fn_IsGUID
(
	@strGUID	varchar(8000)	-- String to be tested
)
RETURNS bit	-- True or False
AS
/*
 * fn_IsGUID	Check that a String is a valid GUID
 *
 * Returns:
 *
 * 	True / False
 */
BEGIN

DECLARE	@blnIsGUID	bit

	SELECT	@strGUID = LTRIM(RTRIM(@strGUID)),
		@blnIsGUID = CASE WHEN @strGUID LIKE 
				'[0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F]-[0-9A-F][0-9A-F][0-9A-F][0-9A-F]-[0-9A-F][0-9A-F][0-9A-F][0-9A-F]-[0-9A-F][0-9A-F][0-9A-F][0-9A-F]-[0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F]' 
			THEN 1
			ELSE 0
			END
	RETURN @blnIsGUID

/** TEST RIG

SELECT	dbo.fn_IsGUID('BFF14A46-19F4-4E8E-BFE1-579E7ABDA3C1')
SELECT	dbo.fn_IsGUID(' BFF14A46-19F4-4E8E-BFE1-579E7ABDA3C1 ')
SELECT	dbo.fn_IsGUID('BFF14A46-19F4-4E8E-BFE1-579E7ABDA3Cx')

**/
--==================== fn_IsGUID ====================--
END
GO
PRINT 'Create function fn_IsGUID DONE'
GO
--

create function IsGuid ( @testString varchar(36))
returns int
as
begin
declare @ret int
if len(@testString) = 36 and not exists(select 1 where @testString like '%[^0-9^A-F^a-f^-]%')
	set @ret = 1
else
	set @ret = 0
return @ret
end
go
--EAB1575F-BCB8-4935-9364-5140F64EE5F7
select dbo.IsGuid ('dAB1,7 F-BCB8-4935-9364-5140F64EE5F7')
select dbo.IsGuid ('dAB1df7F-BCB8-4935-9364-5140F64EE5F7')
select dbo.IsGuid ('dAB1s7F-BCB8-4935-9364-5140F64EE5F7 ')
go
drop function dbo.IsGuid 

quote:

---

Originally posted by spirit1

your answer lies in:
SELECT cast(' BFF14A46-19F4-4E8E-BFE1-579E7ABDA3C1 ' as uniqueidentifier)

Go with the flow & have fun! Else fight the flow

---

create function IsGuid ( @testString varchar(36))
returns int
as
begin
declare @ret int
if len(@testString) = 36 and not exists(select 1 where @testString like '%[^0-9^A-F^a-f\^-]%')
        and charindex('-', @testString) = 9
	and charindex('-', @testString, 10) = 14
	and charindex('-', @testString, 15) = 19
	and charindex('-', @testString, 20) = 24
	and charindex('-', @testString) in (9, 14, 19, 24)
	set @ret = 1
else
set @ret = 0
return @ret
end

If Object_ID('dbo.fnIsGuid') > 0
	Drop Function dbo.fnIsGuid
GO

Create Function dbo.fnIsGuid(@Guid varChar(128)) returns bit

as

Begin
	--Guid format: '22D6CE78-8DBF-426D-8911-337A7277665D'

	declare @i tinyint

	--if first and last characters are curly braces
	--get rid of them
	set @Guid = replace(replace(@Guid, '{', ''), '}', '')

	--uniqueidentifier converts to char(36)
	if len(isNull(@Guid,'')) <> 36
		return 0

	set @i = 1

	while @i < 37 
	Begin
		if @i IN (9,14,19,24)
		Begin
			if subString(@Guid, @i, 1) <> '-'
				return 0
		End
		else if charindex(subString(@Guid, @i, 1), '0123456789ABCDEF') = 0
			return 0

		set @i = @i + 1
	End
	return 1
End

create function IsGuid ( @testString varchar(38))
returns int
as
begin
declare @ret int
set @testString = replace(replace(@testString, '{', ''), '}', '')
if len(isnull(@testString, '')) = 36 and not exists(select 1 where @testString like '%[^0-9^A-F^a-f^-]%')
	and charindex('-', @testString) = 9
	and charindex('-', @testString, 10) = 14
	and charindex('-', @testString, 15) = 19
	and charindex('-', @testString, 20) = 24
	set @ret = 1
else
	set @ret = 0
return @ret
end

create function IsGuid ( @testString varchar(38))
returns int
as
begin
declare @ret int
set @testString = replace(replace(@testString, '{', ''), '}', '')
if len(isnull(@testString, '')) = 36 and not exists(select 1 where @testString like '%[^0-9^A-F^a-f^-]%')
	and charindex('-', @testString) = 9
	and charindex('-', @testString, 10) = 14
	and charindex('-', @testString, 15) = 19
	and charindex('-', @testString, 20) = 24
	and charindex('-', @testString, 25) = 0
	set @ret = 1
else
	set @ret = 0
return @ret
end