Hello Guys: I need to get double quotes around Item DB, but just can't get the syntax correct. I am using C# in an ASPX page. I know: shouldn't use spaces in a database table name, but unfortunately: I inherited this application. Because it is an ASCII / Pervasive connection, I can't use the traditional [ ] around Item DB. sSQL = "SELECT * FROM "" Item DB "" WHERE Item = '" + sItemNumber + "'"; Thanks Andy Mills Programmer Regency Thermographers 717-765-3572 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] http://www.regencythermo.com <http://www.regencythermo.com/>
[Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
