Re: integer to varchar

Article View: borland.public.interbase.sql

Article #11134

Back to borland.public.interbase.sql Previous Next

#11134

From: Arno Brinkman
Date: Mon, 16 Dec 2002 23:13

18 lines
1298 bytes

Hi,

First 1 message is more then enough. If you do everything six-times then...

> how i can transform an integr to a char(varchar) with UDF's
> thanks

Do you mean inside an UDF or the input/output params ?

You can use CAST to convert an INT to an CHAR/VARCHAR.

SELECT
  CAST(SomeIntUDF(AValue) AS CHAR(8))
FROM
  ....

Regards,
Arno

Technical Details

Message-ID: <3dfe5cb1$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3dfe5a49$2@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,9a7c1cfea12ddf30
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-16 15:09:19 PST
From: "Arno Brinkman" <bnewsgroups @ abvisie.nl>
Newsgroups: borland.public.interbase.sql
References: <3dfe5a49$2@newsgroups.borland.com>
Subject: Re: integer to varchar
Date: Tue, 17 Dec 2002 00:13:42 +0100
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 213.117.0.215
Message-ID: <3dfe5cb1$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040080049 213.117.0.215 (16 Dec 2002 15:07:29 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message