subfield equivalent in access?

[Anonymous]

Hello my QlikView friends.  I know this question is a bit backwards, but is there an equivalent of QV's subfield function in Access?  I am trying to reverse engineer something.  Thank you.

[chiru_thota]

Is there an equivalent to the SUBSTRING function in MS Access SQL? - Stack Overflow

[SunilChauhan]

May be

substring

or substr.

Beacuse access works as sqlin some extent

hope this helps