Adding leading zeros no pad

0

Please login or register to vote for this query.

(click on this box to dismiss)

Tridion

Q&A for Tridion developers and administrators

CREATE TABLE #Account_ID(birthdate_new VARCHAR(6));

INSERT INTO #Account_ID 
VALUES ('85934'), ('532149');

select RIGHT('00000000' + birthdate_new, 6)
from #Account_ID

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results