SQL Query - Can I compare using LEN in SELECT clause?

Question

I basically want to do this:

SELECT HasComments = CASE (LEN(Comments) > 1) WHEN 1 THEN 1 ELSE 0 END FROM TableName

In other words, return a boolean telling me whether the length of Comments is greater than 1. This gives me a syntax error.

How can I accomplish this?

Answer 1

SELECT  HasComments = CASE WHEN LEN(Comments) > 1 THEN 1 ELSE 0 END
FROM    TableName

Answer 2

A better way would be to make Comments NULLable and check for that. Indexes could then be leveraged instead of the table-scan LEN() will cause.