Strings

D

Dan @BCBS

I don't understand strings/substring very good.

Sometimes this variable (MBR_GROUPNO) is entered with only 5 digits other
times 7 or 8.

How can I make this where statement capture any that start with 95440?

WHERE (((tblMember.MBR_GROUPNO)="95440"));
 
T

Tom Lake

Dan @BCBS said:
I don't understand strings/substring very good.

Sometimes this variable (MBR_GROUPNO) is entered with only 5 digits other
times 7 or 8.

How can I make this where statement capture any that start with 95440?

WHERE ([tblMember.MBR_GROUPNO] Like "95440*");

Tom Lake
 
D

Dan @BCBS

I won't forget it's so simple... thanks...


Tom Lake said:
Dan @BCBS said:
I don't understand strings/substring very good.

Sometimes this variable (MBR_GROUPNO) is entered with only 5 digits other
times 7 or 8.

How can I make this where statement capture any that start with 95440?

WHERE ([tblMember.MBR_GROUPNO] Like "95440*");

Tom Lake
 
Top