Vinni
New User
Joined: 10 Jun 2008 Posts: 3 Location: Hyderabad
|
|
|
|
Hi,
If i have select some columns using the below statement from a table
IFNULL(a.Col_name_1, CHAR(‘ ‘,10)) as name1,
IFNULL(a.Col_name_3, CHAR(‘ ‘,40)) as name2 from table a.
What does the above statement do exactly ? and name1 can be a column name of another table or it should be some other name if yes do i need to declare it ?
Thanks for the help.
vinni. |
|