>I am converting some routines written in msAccess and came across the following line:
>
>if crsInternet!Q7l like "##MM" then
>
>
>Can someone tell me what the VFP equivalent to the LIKE "##MM" is?
>The field in question is a Character field width 6.
>
>Thanks
I think, it returns data that begins with two digits followed by MM. There is no exact equivalent in VFP. You need to write your own code, like:
if isdigit(crsInternet!Q7l) and isdigit(substr(crsInternet!Q7l,2)) and ;
substr(crsInternet!Q7l,3)="MM"
......