Re: How to use last 10 characters of a 12 char field in Forms?
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 21 Oct 2003 08:06:25 -0700
Message-ID: <1066748798.926695_at_yasure>
Date: Tue, 21 Oct 2003 08:06:25 -0700
Message-ID: <1066748798.926695_at_yasure>
Chris Boyle wrote:
>IF you only want to remove the first two charactero
>
>myVariable := substr(:myBlock.myField);
>
><snipped>
>
>
Let me propose as an alternative:
myVariable := SUBSTR(:myBlock.myField, 3);
If will likely work a lot better.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue Oct 21 2003 - 17:06:25 CEST