Striper Talk Striped Bass Fishing, Surfcasting, Boating - View Single Post

striperman36 · 08-17-2012, 08:56 AM

to convert numbers to char use the to_char function

selection to_char(x,'9999') from tables where

or y = to_char(x,'9999')

the second operator is the mask you want the conversion to use when converting

Pl_SQL obscurity again.

08-17-2012, 08:56 AM	#4
striperman36 Old Guy iTrader: (0) Join Date: Oct 2004 Location: Mansfield, MA Posts: 8,760	to convert numbers to char use the to_char function selection to_char(x,'9999') from tables where or y = to_char(x,'9999') the second operator is the mask you want the conversion to use when converting Pl_SQL obscurity again.