🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.intrabuilder.data.sql
Article #78

Concatenation of strings and numerical-values in SQL

#78
From: Werner Renhardt
Date: Mon, 27 Jul 1998 00:00
18 lines
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-mail

Show 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