>I have the following field: imgFileName
>
>table name is OCRData.dbf
>
>i have the filenames as follows:
>F1GSENT1
>F1GSENT2
>F1GSENT3
>F1GSENT4
>F1GSENT5
>
>
>If i want to get the max value for the filename which has(starting string) F1GSENT it should give me result as 5.
>
>Can you please tell me how i can get Max Value for the field imgFileName with this filename(F1GSENT).
>
>Thank you very much for the information.

Here we go again. What's you definition of 'Max Value' for imgFileName ? Is it the last name in the sort order or the name with the biggest number after 'F1GSENT'? Anyway it was covered in Re: Delete query where condition for a char field greater th Thread #1036736