Re: Convert Char-->integer or Integer-->char

Obnoxio The Clown wrote: > Mark D. Stock wrote: > > >>victor wrote: >> >> >>>Have you got an explication ?? >> >>Well all of that should work, so you must have non-numeric values in >>textos.codigo. You could try filtering out any alpha values, but this all >>goes to show up your database design deficiencies. > > > Don't hold back now, Mark, tell us exactly how you feel about bad database > design... :o) I'm afraid there isn't enough bandwidth to send what I REALLY think about bad database design. ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list

Mark D. Stock wrote: > Obnoxio The Clown wrote: >> Mark D. Stock wrote: >> >> >>>victor wrote: >>> >>> >>>>Have you got an explication ?? >>> >>>Well all of that should work, so you must have non-numeric values in >>>textos.codigo. You could try filtering out any alpha values, but this all >>>goes to show up your database design deficiencies. >> >> >> Don't hold back now, Mark, tell us exactly how you feel about bad >> database design... :o) > > I'm afraid there isn't enough bandwidth to send what I REALLY think about > bad database design. ;-) I see a lot of pleasure in your immediate future. :o) -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche