Gerard,

$ is a VFP thing ... is VFP your backend data?

~~Bonnie


>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