Creating a newfield depending on how the number starts

[memela]

I have this field called number and i want to create new fields depending on how the number begins .

example, numbers that begins with 12 must be on the same field like Number_12 and Numbers that begins with 17 must be on the same field like Number_17.

Number
122
125
123
172
176
182
134

[anat · Accepted solution]

if(left(Num,2)=17,Num) as Num_17,

if(left(Num,2)=12,Num) as Num_12

[memela]

Thank you Anat!!