Using "/" in an sql statement

Results 1 to 3 of 3

Thread: Using "/" in an sql statement

  1. #1
    Eric Swanson Guest

    Default Using "/" in an sql statement

    Our db admin decided to create a field that uses a forward slash "/" in it. When I execute the SQL its finding too many parameters b/c the forward slash separates the field name. Is their a way to work around this or does she have to change her db field name.<BR><BR>strSQL= "SELECT PROJECT, (((Sum(RFAERIAL))+(Sum(RFU/G)))/5280) AS sumpreqcmiles from tblDesignData WHERE DESIGNBILL BETWEEN #" &Request.Form("txtFirstDate") & _<BR>"# AND #" & Request.Form("txtSecondDate") & "# group by PROJECT"

  2. #2
    Join Date
    Dec 1969

    Default I wouldn't call that a db admin...

    but have you tried wrapping the field name with []&#039;s<BR><BR>SUM([RFU/G])<BR><BR><BR>HTH<BR><BR>Jerry

  3. #3
    Eric Swanson Guest

    Default Thanks

    I agree, but out of curiousity, what would you call it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts