Archives of the TeradataForum

Message Posted: Mon, 02 Jun 2008 @ 21:02:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I've been bit with casespecific or non-casespecific data fields. I'd use the following to avoid knowing case and not knowing the complete name.

     WHERE  (upper(WD.EmployeeLastName) LIKE '%'||upper(trim(:LastName))||'%' )

Fred Keiser

HPI - Systems Engineering

	<Prev	Next>		<<First	<Prev	Next>	Last>>