Trimming firsty 3 characters 2

[gscheepers]

Hi,

This is a stupid question, but today I can't remember how to trim off the first 3 characters of a field.

Any help would be appreciated!

Thanks, Gerhard Scheepers
BA - LETEC

 

[chelseatech]

By trim I assume you mean remove and start from the 4th character of the string

Mid({table.field},4)

By not putting a length in as the 3rd paramater, MID returns the rest of the string Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm