Combining expressions in query 1

[hefly]

I am trying to strip the first and last character off of a four character string in a query. The following two expressions work, but I would like to combine expr1 and expr2 into one expression in a query:


T1: Left([T0],Len([T0])-1)
T2: Right([T1],Len([T1])-1)

Thank you for your help.

Hefly

 

[traingamer]

Among other ways:

xxx: Right(Left([T0],Len([T0])-1),Len([T0])-2)

If it is always four characters:

xxx: mid([T0], 2, 2)

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[hefly]

Thank you traingamer!!!

Is it possible to strip a leading Zero (stored as text) from a string?

Thanks again!

Hefly