Viewing post 1 (of 1 total)
substring is working well
select
,left([IDNumber],2) as year
,SUBSTRING(Idnumber,3,2) as Month
,SUBSTRING (Idnumber,5,2) as day
,SUBSTRING(Idnumber ,7,4) as gender
,substring (idnumber ,10,3) nationality
from table
kind...
October 9, 2015 at 2:37 am
#1832470