The power function is only calculated for the five fields!

POWER(0, 2) + POWER(7, 2) + POWER(7, 2) + POWER(0, 2) + POWER(0, 2) is 98

POWER(9, 2) + POWER(0, 2) +...

And welcome to SQLTeam, you are much needed there.

I did not call you insane. Believe me. You are one of the clever people here.

I call oracle_corrgi insane. It is not good to put same question on several forums,...

Already answered here!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73610

Cross posting http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73268

CONVERT with option 108.

Also see this thread or topic

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71510

Collation is the set of characters used to represent your or any other's alphabet.

We in Sweden most often use the FINNISH_SWEDISH collation to be able to view...

You can also use the Levesthein Edit Distance algorithm found here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51540

Cross posting. Topic already answered here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=305549

I think this is a better approach for this task. But you are right otherwise Andrew!

DECLARE @search VARCHAR(10),

 @MaxDigitsWrong TINYINT

SELECT @Search = '1644705509',

 @MaxDigitsWrong = 2

DECLARE @Test TABLE (PartNo...

It is not pretty, but it works.

declare @test table (NoOfItems varchar(100), Quantities varchar(100))

insert @test

select '1,2,10,15,1,1',

 '50,75,20,100,20,25'

DECLARE @Items TABLE (i INT IDENTITY(0,1), Value INT)

INSERT  @Items

  (

   Value

 &nbsp