Skip to content

Instantly share code, notes, and snippets.

@gordonje

gordonje/non_numeric_xref_ids.sql

Created August 31, 2016 16:00
Show Gist options
  • Save gordonje/35f6e6b26d0f57f899c788da31aac8bf to your computer and use it in GitHub Desktop.
Save gordonje/35f6e6b26d0f57f899c788da31aac8bf to your computer and use it in GitHub Desktop.
Download ZIP
xref_ids with non-numeric characters
Raw
non_numeric_xref_ids.sql
SELECT COUNT(DISTINCT "XREF_ID")
FROM "FILER_XREF_CD"
WHERE "XREF_ID" ~ '\D';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment