Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 18 Feb 2010 at 12:55pm
It looks correct, of course without knowing what the data for {employee-emp.status} looks like, it would be hard tell if you are picking up a terminated status that has a 'A' in it.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 18 Feb 2010 at 2:55pm
You described them as a A, L or T with a number after them
If that is the case your LIKE would have to a use the wildcard to handle the 'numbers after them'. That being said I would have thought your select statment as is would exclude all records rather than incluide the extra ones...
{table.startdate} >= Date(2010,01,01) and {employee-emp.status} like "A*"
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum