Escaping forward slash in the query

• snehalata_d

  SSC Veteran

  Points: 281

  More actions

  August 19, 2010 at 3:06 am

  #148451

  Hi,

  I have a query like this.

  select sum(net_underwriting_gain/loss) from <table_name> where <conditions>

  It is not taking / in the column name.

  How do I escape '/' in the query?

  Please help me.

  Regards,

  Snehalata

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  August 19, 2010 at 3:16 am

  #1208949

  Enclose the column name in square brackets ([]).

  John

• snehalata_d

  SSC Veteran

  Points: 281

  More actions

  August 19, 2010 at 3:41 am

  #1208960

  Thanks 🙂