Hi John.
Does the $ syntax work in c# with most backends ?
I thought $ was just a VFP thing ??
Regards,
Gerard
>Gerard,
>
>You could also try
>
>
where cstr $ isr_name
>
>which generally returns the quickest result.
>
>If you are concerned about Case, express cstr as upper case and wrap isr_name in an UPPER() clause
>
>Alternatively you could use the ATC command to ignore case:
>
>
where ATC(cstr,isrname) >0
>
>Regards
>
>j.R