Gene Wirchenko wrote:
> Jeroen van Kalken <I@[EMAIL PROTECTED]
> wrote:
>
>> On Thu, 08 May 2008 14:08:56 -0700, Gene Wirchenko <genew@[EMAIL PROTECTED]
>
>> wrote:
>>
>> in VFP9 you can also use the CAST function to get the right amount of
>> digits; making it slightly more readable/understandable.
>> Like: Cast(nvl(pcl.cpcl,0) as n(10,1))
>
> This is getting messier. It appears that I will be adjusting a
> lot of code.
>
> Is case() ever necessary when a column is being used directly?
> i.e.
> select thiscol,thatcol from ...
> I am hoping that such usage is always safe.
Yes, a single column should be safe. They'll always all be the same width,
by definition.
Dan
|
