Geeks With Blogs

News

Google My Blog

Catch me at: The List!


My InstallScript Utility Belt My Amazon Wishlist
My Standard Disclaimer


Archives
Chris G. Williams Beware: I mix tech and personal interests here.
Earlier today, I ran across some SQL that contained a "!" in a few places, like this:

tablename!fieldname * tablename!fieldname as aliasname

Can anyone clue me in to what that means? (The example in question was taking a quantity, multiplying by price to get an extended price... but I have no clue what the "!" means in this context)

Thanks! Posted on Saturday, August 13, 2005 8:23 PM | Back to top



Comments on this post: Converting SQL from MS Access to SQL Server

# re: Converting SQL from MS Access to SQL Server
Requesting Gravatar...
Yep, seen that in MSAcess SQL. It's the same as a period would be. Simply that. MSAccess uses it's own bastardized version of SQL 92 standard, and that's one of the strange things. It is also used in DAO to references fields off a recordset; so I suspect that it's a chicken/egg thing with regards to which came first. What's really annoying is that often, if you type in the SQL directly and save it, MSAccess in it's attempt to help you, will replace the period with a bang sometimes. No rhyme or reason to when it will or will not, though.

Left by Theo Moore on Aug 14, 2005 11:46 AM

# re: Converting SQL from MS Access to SQL Server
Requesting Gravatar...
well that's annoying. I got around the problem anyway. Apparently the ! can also be used as a conditional operator of some sort, although that's not how it was being used in this particular case.
Left by Blogus Maximus on Aug 14, 2005 11:51 AM

# re: Converting SQL from MS Access to SQL Server
Requesting Gravatar...
Ah, gotcha. And, yes, MSAccess SQL is indeed annoying. I sort of think MS attempted to hijack the standard some with it. I know that all of the major vendors have "extensions" to the standard, but MS actually encourages you to use it's version (bang vs. period) in very sublte ways. Don't think it worked, though. :-)
Left by Theo Moore on Aug 14, 2005 12:09 PM

Your comment:
 (will show your gravatar)


Copyright © Chris G. Williams | Powered by: GeeksWithBlogs.net