Subject: | Re: Query using Alpha field with Numbers
| Date: | 1 Sep 2022 06:33:25 -0400
| From: | "Kevin" <shcsbaker@gmail.com>
| Newsgroups: | pnews.paradox-programming
|
I have values of ONL, Z, DEMO, 1, 2, 3, etc 23, 23.1
Currently I'm using the following in the version field to get anything >
20
21 or 22 or 23..
at version 23 we started subversions
I think the above will just have to work for now.
modridirkac <jure.zorko@gmail.com> wrote:
>What are values for version 7? "07" or "7" ?
>Do you have subversions? "25.1.2"
>
>In a query it would be imposible. You have to cut frrst part of value
>("25") and then convert it to number (25) and then check (>20).
>
>J.
>
>
>On Thu, 01 Sep 2022 10:27:39 +0200, Kevin <shcsbaker@gmail.com> wrote:
>
>>
>> I have a db with a "Version" field. This field is a Alpha field. Is
it
>> possible
>> to build a query with criteria for version > 20
>
>
>--
>Using Opera's mail client: http://www.opera.com/mail/
|