|Sent on:||Friday, January 11, 2008 5:17 PM|
I believe the syntax in MS SQL is [database].[table] so it would be something like
SELECT * from [my_table] where [column_name] LIKE '%foobar%';
Not sure about the quotes around the like. It has been years since I have touched anything MS SQL. Sorry.
On Jan 11,[masked]:31 AM, Chris Verges <[address removed]> wrote:
I apologize for tainting this LAMP list with a Microsoft SQL question, but
it's driving me nuts and I need some help. Under MySQL, I'm able to form
SELECT * from `my_table` where `column_name` LIKE '%foobar%';
The tables and columns are delineated by a tick (`).
This doesn't seem to work in Microsoft SQL, however. Does anyone know what
the corresponding delineated syntax is? And more importantly, is there a
common syntax which will work for both? (Leaving out the delineator mark is
not an option, as we have some table/column names which can conflict with
built-in keywords for the DBMS.)
Thanks for the help!
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed] <mailto:[address removed]> )
This message was sent by Chris Verges ([address removed]) from The Silicon Valley LAMP Meetup Group.
To learn more about Chris Verges, visit his/her member profile: http://lampsoftware.meetup.com/8/members/4884520/
To unsubscribe or to update your mailing list settings, click here: http://www.meetup.com/account/?tab=comm
Meetup.com <http://Meetup.com> Customer Service: [address removed]
632 Broadway New York NY 10012 USA