Search strings with unicode characters

This section applies only to SQL Server databases.

When you specify Simple search criteria for string fields and you switch to Advanced search mode, an "N" is inserted before the string. In this example, you are searching for the EX-002\0001 formula.


R_OBJECT_TYPE = 'FORMULA' AND OBJECTCODE = N'EX-002\0001'