Hi, I want to select record from a table that return empty string or something else that i want, if a column contains null value.
can we do that in a select statement. I tried IsNUll function but it return wither 1 or 0. In MS SQL Server u got a function IsNULL that accepts 2 parameter - first the column name, second the value to be returned if that column contain null value. Is there any function MySQL? Shankar __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
