Delete first and last character?

[kylefield]

Is there a way (in a function) that I delete the first and last character of a string regardless of how long it is?

Thanks.

 

[alvechurchdata]

There's not a single function that will do it but something like:

[TT]Substr(lcText, 2, Len(lcText) - 2)[/TT]

Be careful if you're getting the text from the field of a table. You will have to use TRIM() to take the trailing spaces off.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[cricket]

The leading spaces problem needs also to be addresses

SUBSTR(ALLTRIM(lcText),2,LEN(ALLTRIM(lcText))-2)