[RESOLVED] Is there a reason someone would use this in a sql statement.
Is there a reason someone would use a ^ (caret) in a sql statement? (Microsoft Acccess)
Re: Is there a reason someone would use this in a sql statement.
What does the query look like? The first thing that comes to mind is a bitwise operator.
Re: Is there a reason someone would use this in a sql statement.
SELECT * FROM Table WHERE RecordID ^ -1;
Re: Is there a reason someone would use this in a sql statement.
When I run this query in Access it returns all the rows in table.
Re: Is there a reason someone would use this in a sql statement.
I can't find anything that talks about that exact syntax but ^ as a wildcard means Not In (see here) and as a comparison operator ^= means Not Equals (see here). Those examples are as close as I can find to what you're seeing and I'd guess that in means Not Equals in your case - which would be consistent with the behaviour you're getting.
As for why someone would choose to use an obscure piece of syntax that nobody else has ever come across without commenting their reason for doing so, my guess would be that they were a small minded idiot who wanted to feel important about themself... just sayin'
:)
Re: Is there a reason someone would use this in a sql statement.
