Problem Stored Procedure Count

[re der]

Hello
this is my first post.
I'm migrating a query this on an ASP page to the MySQL engine, with phpmyadmin.

The problem is that I do not get any results, where am I wrong?
This is the SP:

DELIMITER $$
DROP PROCEDURE IF EXISTS `anc_ese`.`sp_count_soci_italia` $$
CREATE PROCEDURE `sp_count_soci_italia`(
IN stranno VARCHAR(10),
OUT TotalCount INT
)
BEGIN
SELECT COUNT(*)
INTO TotalCount
FROM soci
WHERE datai like CONCAT('%', @stranno, '%');
SELECT @TotalCount;
END $$
DELIMITER ;



Edited 1 time(s). Last edit at 05/05/2013 07:10AM by re der.