Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- UPPER not doing anything inside stored proc
October 23, 2005, 10:26 pm
rate this thread
I'm trying to ensure all entries in the database are upper case to keep the
data looking consistent. I've written the following proc but the UPPER()
function doesn't do anything.
CREATE PROCEDURE hospitals_AddHospital (IN HospitalName char(150))
DECLARE strHospital char(150);
SET strHospital = UPPER(HospitalName);
SELECT strHospital AS hospital;
CALL hospitals_AddHospital ('test')
'test' and not 'TEST'
Can anyone advise if this is a known bug, or something within the
functionality I'm not understanding correctly.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum