Technical Article

Campare Case Insensitive  CampareCaseInsensitive

,

Case Insensitive Camparison remains a problem for most developers since SQL Server not supports any built in function for these purpose here is one wich compares varchar strings and returns 1 is mathes and 0 other wise

select dbo.CampareCaseInsensitive('A','a') 

create function CampareCaseInsensitive 
(
@str1 varchar(100),
@str2 varchar(100)
)
returns integer
as
begin

declare @retVal integer
set @retVal=0

if cast(@str1 as varbinary(100))=cast(@str2 as varbinary(100) )
set @retVal=1

return @retVal

end

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Share

Join the discussion and add your comment

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Related content

SQLServerCentral Article

A Normalization Primer

For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

You rated this post out of 5. Change rating

2003-01-13

18,496 reads