To enable automatic conversion of any data type into character/Unicode for comparison with SQL LIKE queries, set the following value:

 

AUTOCONVERTFORLIKE=1

 

Enables any type of non-character data (such as Numeric, Float, Integer, Timestamp, etc.) to be treated as a string for the LIKE operator.

Default = 0.

 

Environments: Client, Windows CDD

Configuration Manager: CDD Settings; Current Key = CONNXCDD; Key Value/Value Name =  AUTOCONVERTFORLIKE