Better alternative to CAST(0 as bit)?

• bvbellomo

  SSChasing Mays

  Points: 643

  More actions

  October 21, 2009 at 9:03 am

  #135790

  I am tired of writing "CAST(0 as bit)" or "CAST(1 as bit)" whenever I need a constant that is typed as a bit. In many computer languages (e.g. C++, C#), you can add a suffix to a number to specify its type. Does anyone know if SQL has this? If not, is there a better way to write this?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  October 21, 2009 at 9:04 am

  #1068931

  Define a variable with type "bit" and assign the value to that. That's what I do.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734459

  More actions

  October 21, 2009 at 9:43 am

  #1068964

  I do what GSquared does. Define a var.