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