"Gene Wirchenko" <genew@[EMAIL PROTECTED]
> wrote in message
news:hg87241haega7mpeje3tf2o1n56og7u520@[EMAIL PROTECTED]
> 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.
Right, Cast() is useful for intentional type conversions and for
"padding" calculated columns, so in an average SQL field list
it might normally be an exception.
hth
-Stefan
--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------
|
