Displaying part of a field

[welshone]

#Hello,
How can I write a SQL Statement to show only part of a field.
eg. I have a number lie 99911123_34545_09999
and I only want to display the 111 part.

What is the function to do this ?

is it like this ?
"Select Distinct MID([filename],3,3) From RepGenA Order by filename"

 

[jtmach]

It should be something like this
"Select Distinct MID([filename],3,3) as midFileName From RepGenA Order by filename"

You have to give the SQL statement a name to call your calculation by. The hardest questions always have the easiest answers.