>You're incrementing wrong variable
> WHILE @intCounter <= LEN(@strMenu)
> BEGIN
> IF SUBSTRING(@strMenu, @intCounter, 1) = CHAR(240)
> SET @intTotalItems = @intTotalItems + 1
> END
>
OMG, I can't believe I missed that! Thank you so much.
________________________
Ben Santiago, MCP & A+
Programmer Analyst (SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS)
Eastern Suffolk BOCES - Student Data Services
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
-Rich Cook