Strings

[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"));

 

[Tom Lake]

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

 

[Dan @BCBS]

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

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