extract substring of a field

in a query i am displaying a text field (for e.g. jobnumber) from a table. i want to add another calculated field in this query such that it will extract the first 4 characters of the jobnumber.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!