Skip to content

Instantly share code, notes, and snippets.

@devacto

devacto/add_padded_identifier.sql

Created November 6, 2013 03:49
Show Gist options
  • Save devacto/7330572 to your computer and use it in GitHub Desktop.
Save devacto/7330572 to your computer and use it in GitHub Desktop.
Download ZIP
Add padded identifier from store codes.
Raw
add_padded_identifier.sql
CONCAT('DS', LPAD(store_code, 4, 0));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment