Re: bad, bad field misuse. need to turn into to SQL.

[Gqcy <gmufasa01@xxxxxxxxx>]

it does,
and this is just lazy crap, that was always justified by
"only 3 lines of code!!!!!" or
"better than the packed strings within the character fields!!!!!"



the snip of sql Glenn and Gary provided does work




On 1/8/2015 9:10 AM, rob@xxxxxxxxx wrote:
> CASTing is the way to go.
>
> On a tangent, does your ERP allow you to specify a different unit of
> measure by item?  Or are there some other silly restrictions?  For
> example, we had a customer who insisted we use inches when we sold them
> wire - and they bought large spools.
>
> Sgt Nick P. :  "Poor boys, they still measure in inches."
>
>
> Rob Berendt