SQL Query Entered Value

[Andyr6381]

Hi I need to write an SQL query to return all results where comments has text in it.

SELECT *
FROM registration
WHERE comments LIKE '%'

returns all, what could I use to just return comments with content

Regards
Andy

[Lars_Berg]

What do you define as content?

Non-null?

SELECT *
FROM registration
WHERE comments is not null

Non-empty string

SELECT *
FROM registration
WHERE comments <> ''

[Andyr6381]

Thanks very much for your help