Hi Bonnie..
The current backend happens to be VFP (Just because I am familiar with VFP and have utilites to fix problems etc), but what I am trying to to in
any Dot Net applications, is to make the code generic ,
so that any Back-end can be selected, by changing a parameter file

Thats the 'Grand Plan' anyway !!

Regards,

Gerard



>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