CHARINDEX infinite loop 1

[VBRookie]

Can anyone tell me why I'm getting an infinite loop on this?

IF CHARINDEX (',' , @Keywords) > 0 
BEGIN
	WHILE CHARINDEX (',' , @Keywords) > 0 
	BEGIN
-- sql statements here
        END
END

@Keywords is passed in and you can assume that it equals 'boy', 'dog'

Please advise? What have I don't wrong? I'm following the example that I found on google.

Many Thanks,
- VB Rookie

 

[bborissov]

WHILE CHARINDEX (',' , @Keywords) > 0
    BEGIN
       -- sql statements here
      SET @Keywords = SUBSTRING(@Keywords,CHARINDEX (',' , @Keywords)+1,99999)
        END
END

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[VBRookie]

YOU ROCK!!!

That fixed it!

Muchas Gracias

- VB Rookie

 

[bborissov]

Be careful, you must be sure that your @KeyWord finished with comma, you could miss last keyword if not.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.