[Gambas-user] Help with converting text in field to number

[werner 007]

Hello Richard

For me it looks you want use "Group By" instead Unions in SQL to get the
Resultset like



> xaxes-text|count|display_order
> -------------------------------------------
>  5-6             5               1
>  6-7           100            2
> over 7       10              3
> 

And to deal with Number vs Text you could use Regexp in MySQL (maybe other
SQL engines too)



> select 
>     reference_range as XAxes_text,
>    ,count (value) as count
>    , at row:=@row+1 as display_order 
> From (SELECT @row:=0) as r, clin_requests.vwResults  
> Where value RegExp '[0-1]'
> Group by reference_range
> 

Just as idea.


Regards, Werner(007)
-- 
View this message in context: http://www.nabble.com/Help-with-converting-text-in-field-to-number-tp21675635p21796806.html
Sent from the gambas-user mailing list archive at Nabble.com.