>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?