informix cast

First question - why on earth are you not storing a numeric value in a numeric column? As already noted, you can use the non-standard Informix cast notation: You can also be more careful about the cast type - using MONEY 8,2 for example. However, strings are compared lexicographicaly and not numericaly, so a CAST is probably wiser in this context - but avoiding the ned for a cast by using the corect type in the first place is wiser stil.
informix cast
Tags: informix cast
| Some Articles: informix cast | Original post: informix cast | Technorati tag: informix cast | Virgilio tag: informix cast