Hi, I need to identify a specific number that matches to certain criteria. This criteria is that is must be 10 digits long and the third last number must be a three (3).
The second one should be a match and will return 'YES' in a new field.
Can anyone assist?
if(len(FIELD) = 10 And Isnumeric(FIELD) AND mid(FIELD,8,1)=3, 'YES', 'NO') as NEW_FIELD
if(len(your_field) = 10 and mid(right(your_field,3),1) = '3' and isNumeric(your_field),1,0)
number like '???????3??'
If(number like '???????3??','Yes','No') as Flag
hope this helps
Retrieving data ...