>Hai,
>When I compare a field of two tables, with the field as alltrim(field1) = alltrim(field2) I get certain records.But when I check the condition as field1 = field2 I get different records and also the count of certain record decreases.What can be the possible reason for such occurence.Wanted the reply immediately.
>
>
>Regards
>Francita.
Francita,
If you set ansi on, you'd get the same results regardless of alltrim.
Cetin