Re: Select Character + Numeric

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

Article #680

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

#680

From: Geoff S. Wass
Date: Sat, 08 Aug 1998 00:00

24 lines
1203 bytes

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.

--
Geoff Wass
Kuala Lumpur, Malaysia


=============================================================
Please respond to a newsgroup posting by posting a reply (not e-mail).
In this way, all can help and all can learn!

Report Inprise/Borland bugs!
http://www.inprise.com/devsupport/bugs/bug_reports.html
=============================================================
Triumph is in the first syllable.

Technical Details

Message-ID: <35CC45CE.8F82A5C8@ibm.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6qhdmj$k8r8@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e0ca2689a5358a7a
X-Google-Attributes: gidff5a1,public
From: "Geoff S. Wass" <gswass@ibm.net>
Subject: Re: Select Character + Numeric
Date: 1998/08/08
Message-ID: <35CC45CE.8F82A5C8@ibm.net>
X-Deja-AN: 379140565
Content-Transfer-Encoding: 7bit
References: <6qhdmj$k8r8@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: Noordindarus Consultancy Sdn. Bhd.
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message