[AccessD] Convert Case to Upper Case

Thanks for the help!  This Should work just fine!!

	-----Original Message----- 
	From: O'Connor, Patricia [mailto:Patricia.O'Connor at dfa.state.ny.us] 
	Sent: Wed 4/14/2004 11:27 AM 
	To: Access Developers discussion and problem solving 
	Cc: 
	Subject: RE: [AccessD] Convert Case to Upper Case
	
	

	Update query using UPPER([fieldname])
	HTH
	
	Patti
	*************************************************************
	* Patricia E. O'Connor
	* Associate Computer Programmer/Analyst
	* OTDA - BDMA
	* (W) mailto:Patricia.O'Connor at dfa.state.ny.us
	* (W) mailto:aa1160 at dfa.state.ny.us
	***********************************************************