On Friday 01 December 2006 11:22, Ed Reed wrote: > I have a problem/question I'd like to find someone else to verify/answer > for me. > > I'm using MySQL 5.1.09 running on Netware. I've created a stored > procedure that has one parameter, > > Create Procedure MyTest(strVal VarChar) > Begin > Select Field1, Field2, Field3 From MyTable > Where Field3=strVal; > End
varchar is meant to be variable, so it MUST have a length supplied. If you want the same flexibility without specifying a specific length, use TEXT instead. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]