Hey Experts .... I'm caught with a difficult SQL problem. I have an array of stock symbols. One in particular is, "ALL". I cycle through the array with a simple FOR...NEXT loop. I use SQL's CREATE command to make each new table. How can I make a new table with a reserved word (or SQL Command)? Is there some special character that I should use to surround the array name to indicate that it may contain a reserved word? I'm using Visual Basic .Net 2008. May each of you have a blessed day the Lord wills. JEP_Dude
Dear SQL Experts.... I'm embarrassed ... How silly of me. This fix was so easy! Please disregard my request for assistance on this topic! May everyone have a blessed day. JEP_Dude
Just to let you know ... The solution was MUCH simpler then I thought. To correct this problem, I added a suffix to the end of each stock symbol after an "_" (underscore) character. Hence, ... the problem was no more! God bless.... JEP_Dude
just use [] brackets this will do your work with all reserved keywords whether u use it as a field name or table name it will work