Query from de 3º caracter of the field

[dtsousa]

i need return data from a field where the user can be able to put 2 caracters in a box presented by the query and then
the query returns data from the 3º caracter of the item

example:
field 'article' with:
01tzc
01txc
01tyc
01tyc

the user puts in the box ´tx´and then the query returns the article '01txc'

The field 'article' has 700 articles

How i can i do this in a query?

 

[llkhoutx]

First put a field in your query to select the first 2 characters of the field:

Expr1:left(Article,2) with a criteria of "tx"

then add another field in

Expr2: right(Article,len(Article)-2) - this allows for the right most portion of Article to be other that a fixed length.