Re: combining a numeric field to an alpha field?

Mike wrote:

Would like to ask this as my starting point; the CALC QBE feature
doesn't appear to have any way to combine a numeric field (in
this case, Short) with an Alpha-defined field to create a new
third field;

Not in QBE, but in Local SQL:

SELECT YourShort, YourAlpha, CAST(YourShort AS CHAR(5)) || YourAlpha
FROM MikesTable

Works with any short because the final length of any short is 5 or less (<
32768)

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.


.