The following statement is attempting to select each record where the numeric MemberID_ field ends in the number 1 and the member belongs to a particular list.
select * from members_ where 'members.MemberID_' like %1 and 'members.List_' = 'listname'
Unfortunately, it seems that the numeric fields don't respond to "like %1".
Can someone point me in the right direction to be able to select a record based on the last digit in a numeric field?
TIA
---
Rick Rountree
select * from members_ where 'members.MemberID_' like %1 and 'members.List_' = 'listname'
Unfortunately, it seems that the numeric fields don't respond to "like %1".
Can someone point me in the right direction to be able to select a record based on the last digit in a numeric field?
TIA
---
Rick Rountree