Select Character + Numeric

Article View: borland.public.vdbase.data.sql

Article #679

Back to borland.public.vdbase.data.sql Previous Next

#679

From: Brian Benson
Date: Sat, 08 Aug 1998 00:00

13 lines
821 bytes

How do I write a 'Select' statement which concatenates a character field
with a numeric field ?

I tried 'Select <character_field> || char(<Numeric_field>) from <table>' but
this gives an error.
Is 'Char' not the function to use ?
or have I got the wrong syntax ?
and where can I find a listing of supported sql functions ?

Brian Benson
Manchester UK

Brian.Benson@BTInternet.com

Technical Details

Message-ID: <6qhdmj$k8r8@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: ff5a1,e0ca2689a5358a7a,start
X-Google-Attributes: gidff5a1,public
From: "Brian Benson" <brian.benson@BTInternet.com>
Subject: Select Character + Numeric
Date: 1998/08/08
Message-ID: <6qhdmj$k8r8@forums.borland.com>
X-Deja-AN: 379133123
Organization: Eureko Ltd
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Newsgroups: borland.public.vdbase.data.sql