MySQL Forums
Forum List  »  Stored Procedures

Re: Help - variable removing leading "0" in stored procedure
Posted by: Emma Middlebrook
Date: January 12, 2006 03:22AM

try:

DECLARE x VARCHAR(50);
SET x = p;

I was referred to this post here with a good explanation of the differences between variables defined with @ and without.

http://forums.mysql.com/read.php?98,62373,62512#msg-62512

HTH,

Emma



Edited 1 time(s). Last edit at 01/12/2006 03:23AM by Emma Middlebrook.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Help - variable removing leading "0" in stored procedure
1353
January 12, 2006 03:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.