Skip to content

Instantly share code, notes, and snippets.

@freshcutdevelopment

freshcutdevelopment/SubstringSQL

Created November 10, 2014 20:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save freshcutdevelopment/6d06f5438174fedb3d79 to your computer and use it in GitHub Desktop.
Save freshcutdevelopment/6d06f5438174fedb3d79 to your computer and use it in GitHub Desktop.
Download ZIP
Returns the substring of a given DB field starting from the last index of the given CHAR input
Raw
SubstringSQL
REVERSE(SUBSTRING(REVERSE([FIELD_NAME]), 0, CHARINDEX('CHAR', REVERSE([FIELD_NAME]))))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment