Archives of the TeradataForum
Message Posted: Mon, 02 Jun 2008 @ 20:06:43 GMT
| Subj: || || Name search in a macro |
| From: || || Pete Jonas |
Good day all, I am trying to do a name search in a macro. I would like to be able to search on the first five characters of a 30 character
varchar field. I am having difficulty making the search work.
replace macro WageDetail2 (LastName varchar(30)) as
from uitables.WageDetail as WD
inner join uitables.Employer as EN
on WD.EAN = EN.EAN
where WD.EmployeeLastName like ':LastName%'
order by WD.SSN,WD.EAN,WD.Cyear,WD.Cquarter;)
Any suggestions would be much appreciated.
Business and Information Technology Unit
MN Department of Employment and Economic Development