Get the third digit of a number

[Dima]

In a query, I need to get the third digit of a student ID. Is there any way to do that?

 

[ColinEssex]

Mid([StudentID],3,1)
Col

 

[tomv]

But first make sure it's at least 3 digits long!

Better might be:

Iif(len(StudentID)<3," ",mid(StudentID,1,3))