Idea Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
SQL Compiler - Not Equal Operator
Status:
Accepting Votes
Submitted by
Matt_S
on
05-25-2021
01:21 PM
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
The SQL compiler within the Input Tool places a space between operators causing a SQL syntax error.
Eg.
SELECT * FROM [DataSource] WHERE [Dimension] != 'abc'
Becomes
SELECT * FROM [DataSource] WHERE [Dimension] ! = 'abc'
The compiler should not add a space in this instance as it violates the syntax rules and triggers an error.
See more ideas labeled with:
2 Comments
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.