Re: character ----> integer

Posted in 1992

Dave Snyder — Fri, 12 Jun 92 20:01:30 EDT — source: Informix-list mailing list archive (1991-1998)

Quoting Josephine Kwan... > > Is there a function in ACE that converts a character field to an integer > field? Can it be easily done in the ACE Report program without > altering the data type in the database? > What I'd do (and I'm not sure if it would work) is have a dummy INTEGER variable. Then when you need to, say: LET intvariable = charvariable Anyone see any holes in that one other than the fact an error will occur if Josephine tries to convert a non-numeric char to a numeric? DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.6 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com