Archives of the TeradataForum

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

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

Hi Pete,

     where WD.EmployeeLastName like :LastName || '%'

this matches your description of "first five characters":

     where WD.EmployeeLastName like sustring(:LastName from 1 for 5) || %'

Dieter

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