Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Sun, Oct 7 2007 1:51 PM	Permanent Link
"Petrus van Breda"	Hi I need to filter records and hope someone can help me? The field is a string field, 16 long. All input are replicated with spaces before so all is right alligned. Number varies from 3 to 16 in length. I need to know all that start with an A. Thanks Petrus
Mon, Oct 8 2007 3:34 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Petrus You should be able to use the LIKE operator or the partial match operator eg Field LIKE 'A%' - my preferred option or Field = 'A*' - making sure you set the partial match flag Roy Lambert
Mon, Oct 8 2007 11:35 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Petrus, << The field is a string field, 16 long. All input are replicated with spaces before so all is right alligned. Number varies from 3 to 16 in length. I need to know all that start with an A. >> Use this: MyDBISAMTable.Filter:='TRIM(LEADING ' ' FROM MyField) LIKE 'A%'; -- Tim Young Elevate Software www.elevatesoft.com
Mon, Oct 8 2007 4:42 PM	Permanent Link
"Petrus van Breda"	Hi Thank you. When I used like all worked fine. Regards Petrus "Petrus van Breda" <petrus@spsoftdev.com> wrote in message news:3F17F449-E6A4-4F5F-B0EC-64CB1398CAE9@news.elevatesoft.com... > Hi > > I need to filter records and hope someone can help me? > > The field is a string field, 16 long. All input are replicated with spaces > before so all is right alligned. Number varies from 3 to 16 in length. > > I need to know all that start with an A. > > Thanks > > Petrus >