Hello Lucas,
[EMAIL PROTECTED] wrote:
I don't see how to use this here, I will have to research the |/||/|
select rpad(|IFNULL(|null, ''),5,'1');
|/||/|
<snip>
The function you want to use is IFNULL() documented
here:http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html
Try it as he wrote it just without the pipes (|):
SELECT RPAD(IFNULL(column_name, ''),5,'1');
Another option to the IFNULL and CASE is the COALESCE function:
http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html
--
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN
Join us at the 2007 MySQL Conference and Exposition
April 23 to 26 - Santa Clara, California, USA
http://www.mysqlconf.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]