Is not > '' working?

CREATE TABLE MyTable

( current_point VARCHAR(20)

)

;

INSERT MyTable SELECT 'Test'

INSERT MyTable SELECT ''

INSERT mytable SELECT ' '

INSERT mytable SELECT NULL

GO

SELECT * FROM mytable

-- 4 rows

SELECT * FROM mytable

WHERE Current_Point IS NOT NULL

-- 3 rows

SELECT * FROM mytable

WHERE Current_Point IS NOT NULL

AND current_point > ' '

-- 1 rows

SELECT * FROM mytable

WHERE Current_Point IS NOT NULL

AND current_point > ''

-- 1 row