Skip to content

Instantly share code, notes, and snippets.

@aaryan79831014

aaryan79831014/SqlToConvert10NDCto11NDC.sql

Created April 16, 2018 21:58
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aaryan79831014/73ebf5f5d34798ed0589dc45e13eb88a to your computer and use it in GitHub Desktop.
Save aaryan79831014/73ebf5f5d34798ed0589dc45e13eb88a to your computer and use it in GitHub Desktop.
Download ZIP
Sql to Convert 10 digit NDC to 11 digit NDC
Raw
SqlToConvert10NDCto11NDC.sql
UPDATE [dbo].[NDCPackage]
SET [NDCPACKAGECODE]=
(
CASE CHARINDEX('-', [NDCPACKAGECODE])
WHEN 5 THEN REPLACE('0'+SUBSTRING([NDCPACKAGECODE],CHARINDEX('', [NDCPACKAGECODE]), LEN([NDCPACKAGECODE])+1), '-', '')
WHEN 6 THEN CASE (CHARINDEX('-', REVERSE([NDCPACKAGECODE])))
WHEN 3 THEN REPLACE(LEFT([NDCPACKAGECODE], (CHARINDEX('-', [NDCPACKAGECODE])))+'0'+SUBSTRING([NDCPACKAGECODE], CHARINDEX('-', [NDCPACKAGECODE])+1, LEN([NDCPACKAGECODE])), '-', '')
WHEN 2 THEN REPLACE(STUFF([NDCPACKAGECODE], LEN([NDCPACKAGECODE])- CHARINDEX('-', REVERSE([NDCPACKAGECODE]))+1, 1, '0'), '-', '')
END
END
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment