Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Filter |
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 > |
This web page was last updated on Tuesday, April 23, 2024 at 08:10 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |