SELECT * WHERE LENGTH('id') > 2

[mameha1977]

I want to select all data where the description field is not empty.

I tried like this:

SELECT *
FROM table
WHERE LENGTH('description') > 1

but I think my use of LENGTH is wrong and it returns empty result...

[arcware]

Try this (MSSQL query)

SELECT * FROM TABLE WHERE description <> '' And description IS NOT NULL

Thanks