On Fri, Nov 21, 2003 at 11:47:42 -0600, Yudie <[EMAIL PROTECTED]> wrote: > Hi guys, > > I know it's impossible to just cast varchar to any numeric datatype, > but is there another function/ custom function or any way to force to do > that convertion.
You can use to_number to go from text to numeric. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]