integer to varchar

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by chimo Mon, 16 Dec 2002 22:57

#11130

Author: chimo
Date: Mon, 16 Dec 2002 22:57

2 lines
1008 bytes

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

Re: integer to varchar

#11134

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads