-
Nov 15th, 2012, 01:09 PM
#1
Thread Starter
Fanatic Member
[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)
-
Nov 15th, 2012, 01:42 PM
#2
Addicted Member
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.
-
Nov 15th, 2012, 02:15 PM
#3
Thread Starter
Fanatic Member
Re: Is there a reason someone would use this in a sql statement.
SELECT * FROM Table WHERE RecordID ^ -1;
-
Nov 15th, 2012, 02:18 PM
#4
Thread Starter
Fanatic Member
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.
-
Nov 16th, 2012, 04:11 AM
#5
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'
The best argument against democracy is a five minute conversation with the average voter - Winston Churchill
Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd
-
Nov 16th, 2012, 06:25 AM
#6
Re: Is there a reason someone would use this in a sql statement.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|