Skip to content

Instantly share code, notes, and snippets.

@meau

meau/CSboxesNoFolder

Last active August 29, 2015 14:21
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 meau/a706904489486c2763b9 to your computer and use it in GitHub Desktop.
Save meau/a706904489486c2763b9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CSboxesNoFolder
UPDATE mssa.archdescriptioninstances
SET
container2AlphaNumIndicator = RIGHT(container1AlphaNumIndicator,
LOCATE('F', container1AlphaNumIndicator) - 2),
container1AlphaNumIndicator = LEFT(container1AlphaNumIndicator,
LOCATE('F', container1AlphaNumIndicator) - 1),
container2Type = 'Folder'
WHERE
container1AlphaNumIndicator LIKE '%CS%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment