Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Convert Numeric Values to Character Strings
How To Convert Numeric Values to Character Strings? - MySQL FAQs - Introduction to SQL Basics
✍: FYIcenter.com
You can convert numeric values to character strings by using the CAST(value AS CHAR) function as shown in the following examples:
SELECT CAST(4123.45700 AS CHAR) FROM DUAL; 4123.45700 -- How to get rid of the last 2 '0's? SELECT CAST(4.12345700E+3 AS CHAR) FROM DUAL; 4123.457 SELECT CAST(1/3 AS CHAR); 0.3333 -- Very poor conversion
2007-05-11, 5471👍, 0💬
Popular Posts:
What is XSLT? XSLT is a rule based language used to transform XML documents in to other file formats...
What are urlencode() and urldecode() functions in PHP? string urlencode(str) - Returns the URL encod...
In which event are the controls fully loaded ? Page_load event guarantees that all controls are full...
What is the significance of Finalize method in .NET? .NET Garbage collector does almost all clean up...
How can you determine the size of an allocated portion of memory? You can't, really. free() can , bu...