Use [] e.g.
INSERT INTO [card information]([card number]) values(1); Ken Wexel Senior Programmer Analyst Verian Technologies 8701 Mallard Creek Road Charlotte, NC 28262 ProcureIT- Spend Management for Your Enterprise mailto:[EMAIL PROTECTED] http://www.verian.com/ Verian Technologies Named to Supply & Demand Chain Executives' Top 100 List Four out of Five Years http://www.sdcexec.com/article.asp?article_id=7377 Global Logistics & Supply Chain Strategies Readers Name Verian Technologies as one of Top 100 Supply Chain Partners for Second Year http://glscs.texterity.com/glscs/200507/?pg=30&pm=2 Verian Technologies Named one of Inbound Logistics 2005 Top 100 IT Logistics Companies http://www.verian.com/PressReleases/documents/PRInboundLogisticsTop100.htm -----Original Message----- From: David Elliott [mailto:[EMAIL PROTECTED] Sent: Friday, April 14, 2006 2:48 PM To: CF-Talk Subject: Insert SQL Statement Poor planning on my part but, I have a table on an sql server named 'card information'. It is two words. There are 5 rows inside this table. They two are made up of names like 'credit card number' or 'amount of charge' (all without the punctuation[. It looks like the rows are working just fine. However, I am unsure how to deal with the two word table name. Any suggestions? Thanks, Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237792 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
