MySQL SQL - How To Convert Numeric Values to Character Strings

How To Convert Numeric Values to Character Strings

Q

How To Convert Numeric Values to Character Strings? - MySQL FAQs - Introduction to SQL Basics

✍: FYIcenter.com

A

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, 4896👍, 0💬

What Happens If NULL Values Are Involved in Expressions
What Happens If NULL Values Are Involved in Expressions? - MySQL FAQs - Introduction to SQL Basics If NULL values are used in expressions, the resulting values will be NULL values. In other words: Arithmetic expressions with NULL values result NULL values. Comparison expressions with NULL values res... 2007-05-11, 4511👍, 0💬

What Are NULL Values
What Are NULL Values? - MySQL FAQs - Introduction to SQL Basics NULL is a special value that represents no value. Here are basic rules about NULL values: NULL presents no value. NULL is not the same as an empty string ''. NULL is not the same as a zero value 0. NULL can be used as any data type. NUL... 2007-05-11, 4495👍, 0💬

How To Convert Character Strings to Numeric Values
How To Convert Character Strings to Numeric Values? - MySQL FAQs - Introduction to SQL Basics You can convert character strings to numeric values by using the CAST(string AS DECIMAL) or CAST(string AS SIGNED INTEGER) function as shown in the following examples: SELECT CAST('4123.45700' AS DECIMAL) F... 2007-05-11, 4366👍, 0💬

How To Use IN Conditions
How To Use IN Conditions? - MySQL FAQs - Introduction to SQL Basics An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the tutorial exercise below: SELECT 3 IN (1,2,3,4,5) FROM DUAL; ... 2007-05-11, 4227👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.