[RESOLVED] Is there a reason someone would use this in a sql statement.

[mojo69]

Is there a reason someone would use a ^ (caret) in a sql statement? (Microsoft Acccess)

[smendoza]

What does the query look like? The first thing that comes to mind is a bitwise operator.

[mojo69]

SELECT * FROM Table WHERE RecordID ^ -1;

[mojo69]

When I run this query in Access it returns all the rows in table.

[FunkyDexter]

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'

[TysonLPrice]

Seems to be related to this post:

http://www.vbforums.com/showthread.p...L-Statement-do