🚀 go-pugleaf

In article <368292e6.6580270@forums.inprise.com>, 
skoterski@NOSPAMinprise.com says...
> In SQL, the function SUBSTRING is provided to retrieve part of a string
> (CHAR) value. However, SUBSTRING works only on string type values and your
> calculation results in a numeric type value. So you would need to take the
> extra step of converting the numeric value to string using the CAST
> function.
> 
Steve,

I am using Visual dBASE 5.6 and it doesn't seem to accept the CAST 
function like version 7.0 does.  On the other hand, 5.6 seems to be 
comfortable in returning the first character from a _NUMERIC_ value with 
the SUBSTRING function which version 7.0 will not...go figure!

Furthermore, I have run into the situation where an involved 
age calculation will return correct values when run by itself, but when 
combined with the rest of the SQL SELECT statement that I need that also 
runs OK by itself or OK with _CERTAIN_ calculations to produce an age 
value; the combination returns zero records.  I have not been able to get 
around this obstacle to get exactly what I want.

Thanks for your input.  I was hoping to hear from you.

Gerald