One thing I neglected to mention is that where the context is ambigious, " (double quotes) are treated as string delimiters in MySQL, and I'd expect the same in MS SQL. Take this query:
SELECT "order" FROM myTable It's ambigious whether that means select the string literal "order", or if it means select the column named "order". MySQL will assume the former. In my previous examples, the " (double quote) delimted item was the name assigned by an AS clause so it could only be an escaped identifier. cheers, barneyb On Mon, 31 Jan 2005 23:06:50 -0600, Nick Baker <[EMAIL PROTECTED]> wrote: > Super explanation. > > Many Thanks, > > Nick > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 6 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192675 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
