Please explain this query

Database
Enthusiast

Please explain this query

Hi All,

I have a query like below

select col1, col2 from table1
where col1 >  '      ' -- Six space inside the quotes

Here col1 is char(6) column, what is the use of this?

Tags (1)
1 REPLY
Enthusiast

Re: Please explain this query

Hi Barani_Sachin,

If you have nulls, spaces(only),blanks in col1, these records will be filtered out using above condition.