sorting with string

[Ruslan Zasukhin]

On 9/27/05 6:11 PM, "Jules Jacquot" <jules.jacquot at wanadoo.fr> wrote:

Hi Jules,

Please look docs about CollationAttribute.

It have mention about attribute as NumericSorting
    
Set this attribute for this field (or the whole db).


> hi, ruslan
> 
> because the variable URIB is a string = "1","2","3", .....
> 
> this request
> 
>      MoCurs=app.mdatabase.SQLSelect("select RecID,* from Bordereau
> order by URIB")
> 
> gives
> 
> 1
> 10
> 11
> ..........
>       i would like
> 1
> 2
> 3
> 4
> ...........
> 
> how can i do ?
> 
> thanks very much

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]