Strings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"));
 
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?
Click to expand...

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

Tom Lake
 
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?
Click to expand...

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

Tom Lake
Click to expand...
 
Back
Top