williamluisan/gist:888e834a6a767ce80a7e98e5757198a1

Created May 10, 2021 16:49

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/williamluisan/888e834a6a767ce80a7e98e5757198a1.js"></script>
Save williamluisan/888e834a6a767ce80a7e98e5757198a1 to your computer and use it in GitHub Desktop.

Download ZIP

An example of replacing chars at the left of SQL string

Raw

gistfile1.txt

	REPLACE('62', SUBSTR(service_number, 1, 2), CONCAT('0', SUBSTR(service_number, 3, 9999)))

	# Result:
	## From '6282190872222' to '082190872222'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment