How do we display records in a Table which are filled with blank space /white space.
For ex:
Select * from employee where dept_name ='sales' or dept_name in (' ') ;
I want this query return all the rows with dept name as sales and also the rows with dept_name filled with blank space.
Is there any thing similar to the query written above we can use to get the desired output? (Like using dept_name in (' ') to get rows with blabk space)