OK, that makes sense and the MemberID_ field is integer (int).
This is the revised statement that works:
select * from members_ where MemberID_ % 10 = 1 and List_ = 'listname'
Thanks!!
---
Rick Rountree
http://www.dundee.net/isp/
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...
Change that last post to read "right click on taskbar, click on properties, and uncheck appropriate checkbox"
---
Rick Rountree
http://www.dundee.net/isp/
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.