From: Jeff Smelser
Date: December 23 2004 3:10pm
Subject: Re: Alternatives to Oracle's TO_CHAR()
List-Archive: http://lists.mysql.com/mysql/177652
Message-Id: <200412230910.48386.tradergt@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed;
  boundary="nextPart5490536.NpLckmgznC";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart5490536.NpLckmgznC
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Wednesday 22 December 2004 12:02 pm, Philip Barlow wrote:

> I am working on a query that was built for Oracle databases but I need
> to make it compatible with MySQL. Basically I need to convert or cast an
> INT as a CHAR. The Oracle query just uses TO_CHAR() to achieve this but
> I am stumped in my search for an equivalent method in MySQL or even an
> alternative. Any help, hints or suggestions are welcome,

Cast will work, its in every DB..

Jeff

--nextPart5490536.NpLckmgznC
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQBByt/4oOk9EvUvEtgRAsszAKCaaw1fSVqJluJqE/tU3BsLg0PUVgCfaOxq
as/pkHahkLQdIgCY2RZyweM=
=PGnk
-----END PGP SIGNATURE-----

--nextPart5490536.NpLckmgznC--