>Using Linq, if I have a where clause with an equal sign about a character 10 field, do I have to specify something specific to assure an exact match or this is considered as is in Linq?
>
>This is an example:
>
>
> oClient = (From c
> In oClient.ClientService.Clients()
> Where c.Id = cClientID).FirstOrDefault()
>
>
>Because, if I have a Id field having values 123 and 1234, again for a Char(10) field, how can I be sure that searching for 123 will find the record having 123 for the ID and not 1234?
AFAIK, it is an exact match in c#. 123 != 1234. Is VB case specific? Are there ANSI settings like VFP?