Paradox Community

Items in pnews.paradox-programming

Subject:Re: Query using Alpha field with Numbers
Date:2 Sep 2022 16:59:15 -0400
From:"Kevin Zawicki" <numberjack@wi.rr.com>
Newsgroups:pnews.paradox-programming



That works unless you start to use sub sub versions 21.1.1,etc


Also having these as alpha will not sort them (maybe) the way you want (if
you care). You would be sorting numbers alphabetically.

1
10
100

etc


You could use a tcursor and parse these into a temp table or array and cast
as numbers

or
break on    .  and get two parts (or more if sub sub version) 


leading zeroes can also come into play



Leslie <"ViaThe List"@NOSPAM.com> wrote:
>Use Local SQL and the Cast operator
>
>On 1/09/2022 6:27 PM, Kevin 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
>>
>
>-- 
>This email has been checked for viruses by Avast antivirus software.
>www.avast.com


Copyright © 2004 thedbcommunity.com