Special characters in object names and identifiers

The following special characters that are used in SQL Server calls to the MES database should not be used for MES object names and IDs:

• % (percent)

• _ (underscore)

• ^ (carat)

• [ or ] (square brackets)

MES objects can be a physical entity, a line, an item, a work order, a lot, an attribute or other objects that can be added to the MES database.

Using these characters can cause unexpected behavior when retrieving records from the MES database, such as missing or extra objects being returned.  

Specifically, these special characters are used by SQL Server calls that use the LIKE operator. For more information about this operator and how these characters are used in a LIKE expression, see the LIKE (Transact-SQL) topic in the Microsoft SQL Reference document.