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

Posted in 2003

victor — Thu, 4 Dec 2003 10:43:00 +0100 — source: Usenet: comp.databases.informix

Hi , I have tried, but I have an error 1213. I think I am wrong somewhere. Here is my tables : Tables textos : textos type codigo char(30) With codigo = 1, 15,20,34 etc... Table Lots : Lots type lot integer with lots.lot = 1,15,20,34 etc ... I need this "request" select textos.codigo from textos,lots where textos.codigo=lots.lot;This don't work it is normaly because type is different So as you say I try this: select textos.codigo+0 from textos,lots where textos.codigo=lots.lot So I have an 1213 error --> A character to numeric conversion process failed. I try : select textos.codigo::INT from textos,lots where textos.codigo=lots.lot So I have an 201 error --> Syntaxe error as occurred Have you got an explication ?? Thanks for your help. Victor