Additional VARCHAR VARGRAPHIC VARBINARY ROWID and XML fields considerations
For these data types, a two-byte length precedes the character, graphic, or hexadecimal data.
The length does not include the two length bytes. For VARCHAR, VARBINARY, ROWID, and XML, the length is the number of bytes. For VARGRAPHIC, the length is the number of double-byte characters.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*