Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Finds invalid characters in any Sitecore field
SELECT * FROM (
SELECT ItemId, FieldId, Value FROM [SharedFields] (nolock)
UNION
SELECT ItemId, FieldId, Value FROM [UnversionedFields] (nolock)
UNION
SELECT ItemId, FieldId, Value FROM [VersionedFields] (nolock)
) A
WHERE Value Like '%' + CHAR(0x01) + '%'
OR Value Like '%' + CHAR(0x08) + '%'
OR Value Like '%' + CHAR(0x10) + '%'
OR Value Like '%' + CHAR(0x12) + '%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment