Article View: borland.public.vdbase.data.sql
Article #681Re: Select Character + Numeric
From: Brian Benson
Date: Sun, 09 Aug 1998 00:00
Date: Sun, 09 Aug 1998 00:00
22 lines
1218 bytes
1218 bytes
Geoff S. Wass wrote in message <35CC45CE.8F82A5C8@ibm.net>... >Brian, > >I'm no SQL expert... but I would look at the CAST clause. > >This is untested: > >SELECT yourChar || CAST yourNum AS CHAR .... > >I don't even have my SQL books with me to look this up, so the syntax >may not be correct. I hope this points you to a solution. > Thankyou Geoff, I have tried various combinations without success. I have found the localSQL helpfile and have come to the conclusion that although CAST and CHAR are reserved words neither these nor most other SQL functions are supported since they do not appear in the helpfile index. Perhaps someone more familiar with visual-dBase SQL could comment . Brian
Technical Details
Message-ID:
<6qkgsd$ofg7@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6qhdmj$k8r8@forums.borland.com> <35CC45CE.8F82A5C8@ibm.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,e0ca2689a5358a7a X-Google-Attributes: gidff5a1,public From: "Brian Benson" <brian.benson@BTInternet.com> Subject: Re: Select Character + Numeric Date: 1998/08/09 Message-ID: <6qkgsd$ofg7@forums.borland.com> X-Deja-AN: 379436535 References: <6qhdmj$k8r8@forums.borland.com> <35CC45CE.8F82A5C8@ibm.net> X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Organization: Eureko Ltd Newsgroups: borland.public.vdbase.data.sql