Archives of the TeradataForum

Message Posted: Mon, 02 Jun 2008 @ 23:33:00 GMT

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

Hi Pete:

If I understand your requirement, you might be making this harder than it needs to be:

What if:

     where WD.EmployeeLastName(char(5)) = :LastName(char(5))

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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