How to select via last digit in numeric field? 1

[devnull4u]

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

http://www.dundee.net/isp/

 

[vongrunt]

How about where MemberID_ % 10 = 1 ... ?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[devnull4u]

Nope...that returned nothing. What is the % 10 = 1 supposed to do?



---
Rick Rountree

http://www.dundee.net/isp/

 

[vongrunt]

% is modulo operator. It return remainder after division. So X % 10 returns... last digit, assuming that memberID_ is integer and NOT char/varchar/whatever.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[jbenson001]

Try"
[code}
select * from members_
where Right(members.MemberID_ , 1) = 1
and members.List_ = 'listname'
[/code]

 

[devnull4u]

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/