CASTING

[Anton]

How could I compare two fields one of which is of integer type, the other is char?
The version of the INFORMIX is 7.2.
Thanks in advance.

[Art S. Kagel]

On Tue, 15 Jul 2003 02:52:54 -0400, Anton wrote:

> How could I compare two fields one of which is of integer type, the
> other is char? The version of the INFORMIX is 7.2. Thanks in advance.

Where? In an SQL statement? If the char column only contains numeric
characters you can compare the two columns directly the engine will
decide the most efficient conversion (char->int or int->char) for the
comparison based on the tables and statistics. In 9.xx you can use a
cast:


WHERE char_col = CHAR::int_col

Art S. Kagel

[Melissa]

Does anyone know of way in ASP to cast an integer to a string?

Thanks,
Melissa

[Dan Brussee]

cstr(x)

On Wed, 22 Oct 2003 19:50:30 -0700, "Melissa" <mc1204@hotmail.com>
wrote:

>Does anyone know of way in ASP to cast an integer to a string?
>
>Thanks,
>Melissa
>

[Mark Schupp]

What language?

For VBScript use
CStr(num)

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"Melissa" <mc1204@hotmail.com> wrote in message
news:_lHlb.33354$Rd4.25812@fed1read07...

> Does anyone know of way in ASP to cast an integer to a string?
>
> Thanks,
> Melissa
>
>