Extract characters by position in a string

[deemat]

I'm trying to extract the 6th and 7th position characters in a string. But I'm getting those characters plus the remaining characters in the field. Example, If I have 65478HTGF.
I need to just show HT.

I am using Mid(table.field,6.7) but I get HTGF as a result. Any help would be greatly appreciated. Thanks,

 

[AndyMc]

Mid(table.field,6,2)

 

[deemat]

Thank you. That worked.

 

[pmax9999]

An alternative approach (and Crystal almost always has more than one way to achieve what you want) would be:

{table.field}[6 to 7]

Cheers
Pete