Post reply

Characters in field names

  • November 3, 2011 at 1:34 pm

    #250351

    Is it okay to have a field name like -

    Fixed/Float/Step (Interest Rate Type)

  • November 3, 2011 at 1:38 pm

    #1402914

    sure but you'll have to make sure you always wrap it in brackets when refering to it:

    WHERE [Fixed/Float/Step (Interest Rate Type)] = 42

    to avoid that, you want to go witht eh standard naming conventions: starts with a letter, no spaces, contains letters,numbers and underscores only.[Fixed_Float_Step__Interest Rate Type_]?

    the name is awful long, and with spaces and special characetrs...i'd consider renaming it to something more business-meaningful, and shorter, ...what's wrong with [Interest_Rate_Type]

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 3, 2011 at 1:41 pm

    #1402916

    Lowell (11/3/2011)

    sure but you'll have to make sure you always wrap it in brackets when refering to it:

    WHERE [Fixed/Float/Step (Interest Rate Type)] = 42

    to avoid that, you want to go witht eh standard naming conventions: starts with a letter, no spaces, contains letters,numbers and underscores only.[Fixed_Float_Step__Interest Rate Type_]?

    the name is awful long, and with spaces and special characetrs...i'd consider renaming it to something more business-meaningful, and shorter, ...what's wrong with [Interest_Rate_Type]

    Then you those who don't like the underscore and would go with InterestRateType.

  • November 3, 2011 at 2:00 pm

    #1402923

    Thanks everyone!

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply