Article View: borland.public.intrabuilder.data.sql
Article #78Concatenation of strings and numerical-values in SQL
From: Werner Renhardt
Date: Mon, 27 Jul 1998 00:00
Date: Mon, 27 Jul 1998 00:00
18 lines
1286 bytes
1286 bytes
Concatenation of strings and numerical-values in SQL:
I have a table e.g. (a Paradox-Table named "Table.db") with the columns:
TabID (Integer - long)
TabName (alphanumeric)
I want to generate a Query which concatenates 'TabID' and 'TabName'.
( SELECT TabID, (TabID || TabName) As TabIDName FROM "Table.db"
<- but this works only when TabID is already a String-value;
Auto-Conversion of numerical values to strings does not work. )
My Problem:
How can I cast the numerical value 'TabID' to a String-value?
I've found no function (e.g. Str(<Number>))
I've found no operator (e.g. & (Ampersand) in ACCESS which implicit
casts numerical values to Strings)
There is no hint in the 'Localsql.hlp' of BDE
and the IntraBuilder-Helpfile
Technical Details
Message-ID:
<6pi5lo$94113@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 101d9a,7fe303948be618ed,start X-Google-Attributes: gid101d9a,public From: "Werner Renhardt" <werner@kangaroo.nwy.at> Subject: Concatenation of strings and numerical-values in SQL Date: 1998/07/27 Message-ID: <6pi5lo$94113@forums.borland.com> X-Deja-AN: 375327993 Organization: Another Netscape Collabra Server User X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Newsgroups: borland.public.intrabuilder.data.sql