Thanks Buddy,

But still issue exists as it fails when we compare normal strings.

DECLARE @C NVARCHAR(10),@R NVARCHAR(10)

SELECT @C=N'Ant'

SELECT @r=N'ant'

IF @r = @C COLLATE Latin1_General_Bin

SELECT 1

ELSE

SELECT 2

As per...

Thanks Buddy...

Actually we have used newid() in order by clause to do shuffling.But My Manager is asking me to get the algorithm used for that clause and need to compare with...

Hi Keon,

I Gone through the site,but i failed to get exactly which algorithm used?