KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I want to have compatible SQL for both Oracle database and Microsoft SQL server. I want a compatible SQL expression that will return true for not null and not empty strings. If I use: column <> '' it will work on Microsoft SQL server but not on Oracle database (as '' is null for Oracle) If I use: len(column) > 0 it will work on Microsoft SQL server but not on Oracle database (since it uses length() )
Tags (comma-separated)
Save Edits
Cancel