SET EXACT OFF ?'Domestic Chassis LED '== 'Domestic Chassis LED' && .F. SET EXACT ON ?'Domestic Chassis LED '= 'Domestic Chassis LED' && .T....makes your point very well. If I had given these examples as well in my earlier post, it would have been more informative as to the differences. Thank you for the additional clarification.
>SET EXACT OFF >?'Domestic Chassis LED' = 'Domestic Chassis' && .T. -- only len('Domestic Chassis') is checked to see if it matches >?'Domestic Chassis' = 'Domestic Chassis LED' && .F. > >?'Domestic Chassis LED' == 'Domestic Chassis' && .F. >?'Domestic Chassis' == 'Domestic Chassis LED' && .F. > >SET EXACT ON >?'Domestic Chassis LED' = 'Domestic Chassis' && .F. >?'Domestic Chassis' = 'Domestic Chassis LED' && .F. >>
>CLEAR >SET EXACT OFF >?'Domestic Chassis LED' = 'Domestic Chassis' && .T. >?'Domestic Chassis' = 'Domestic Chassis LED' && .F. >?'Domestic Chassis LED '= 'Domestic Chassis LED' && .T. > >?'Domestic Chassis LED' == 'Domestic Chassis' && .F. >?'Domestic Chassis' == 'Domestic Chassis LED' && .F. >?'Domestic Chassis LED '== 'Domestic Chassis LED' && .F. > > >SET EXACT ON >?'Domestic Chassis LED' = 'Domestic Chassis' && .F. >?'Domestic Chassis' = 'Domestic Chassis LED' && .F. >?'Domestic Chassis LED '= 'Domestic Chassis LED' && .T. >>
>XBASE "=" respect COLLATE but "==" use MACHINE only >SQL "=" and "==" respect COLLATE >