Re: how to convert datatypes ?

Michael Agbaglo wrote: > > First I had to write extra code because this amateur programmers a informix > weren't able to implement select ... into ... order by. > Then I browsed the manuals for 'convert' w/o success. When I do a > LET Stmt = VARCHAR( foo ); > it thinks VARCHAR is a procedure --- Arrgh! > Then I browsed for string functions - nothing, no MID, LEFT, RIGHT... > Have they been exhausted by implementing 'LENGTH' ? > > If someone what's to implement a shit app - forget it Informix already did > it ! =============================================================================== I just wanted to applaud everyone who replied to this posting, who could figure out what the hell this idiot was talking about. If the subject line was the real question, the poster might want to look at ex30.4gl, one of the sample programs supplied with the 4GL. This is a great exersize in understanding how to convert data types stored in syscolumns. The posted responses to this syphilitic rambling also point out the 4GL can convert data types on the fly using the LET statement. But I'm not sure this is what was pursued, noticing the foam drippings on the message. Where is Spock when we need him to apply a little pressure on the neck? :-) -- Tim Schaefer \\\\|// tschaefe@mindspring.com (6 6) ------------------------oOOo---( )---o00o--------- Liberty: http://www.lp.org Informix: http://www.iiug.org --------------------------------------------------