Re: Help - variable removing leading "0" in stored procedure

[John Constantine]

Hi,

Thanks for your comments Emma.

I've tried fidling with that but to no luck. I've tried setting the variable as follows too :

use mydbwhatever;
DELIMITER //
CREATE PROCEDURE P1(p VARCHAR)
BEGIN
DECLARE x VARCHAR(50)
SET @x = p;
select @x ;
END;
//

It doesn;t complain about this setup above but it still strips the 0.

I've also tried setting it to TEXT/blob/CHAR too , but to no effect:-(

Any thoughts appreciated.

Thanks

JC