Subject: | Re: Query using Alpha field with Numbers
| Date: | Thu, 1 Sep 2022 09:12:41 -0500
| From: | Mark Bannister <markRemove@THISinjection-moldings.com>
| Newsgroups: | pnews.paradox-programming
|
You could add a master table to your version field that holds a numeric
value or some sort of other sorting value(s).
On 9/1/2022 5:33 AM, Kevin wrote:
> 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
>>
>>
>>
--
Mark Bannister
|