CHR function in MySQL

[sebes]

Hola,

From what I understand, there's no CHR() function in MySQL or something to correspond to CHR from VFP.

(|Example: CHR(65) returns "A")

If anybody has an idea how to "simulate" it, please advise.

Thanks.

 

[vacunita]

There is a function called CHAR() which does the same thing. It can event take more than one integer parameter and return the string generated from them:

SELECT CHAR(65 using ASCII)  ==> returrns "A"
SELECt CHAR(66,65,68 using ASCII) ==> returns "BAD"

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[sebes]

Ca I use it in something like:

SALECT .... WHERE field = CHAR(66,65,68 using ASCII) ?

Thanks.

 

[vacunita]

Yes sure.

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[sebes]

Right, I tested it already and it works.

Now, can I use something like this ?

Thanks