Message: previous - next
Month: January 2002

Re: [Pvx] Show part of string in Query

From: "Jane Raymond @ home" <jane.raymond@...>
Date: Thu, 24 Jan 2002 21:00:24 -0500

When you define the columns in your query, press the 'Add Formula' button
and enter an expression such as MID(YOURFIELD$,4) in the Formula multiline.
This should display from the fourth character to the end (i.e. the last
four).  Using the MID() function is safer that using the substring
(YOURFIELD$(4) for example) as you won't get an error if the string is less
than four characters long.

Jane Raymond <jane.raymond@...>
Best Software Canada Ltd. (Providex)
Tel. 905-470-1024 x224

----- Original Message -----
From: "Francisco Gutierrez" <aspica@...>
To: <providex@...>
Sent: Thursday, January 24, 2002 7:43 PM
Subject: [Pvx] Show part of string in Query

Hi list,

How can i show part of string in a query, this field have sevent (7) pos and
i need to show only the four (4) last pos.

Any help is welcome


Francisco Gutierrez
Valencia - Venezuela