Cast wrong

• Corobori

  Ten Centuries

  Points: 1316

  More actions

  February 16, 2006 at 7:17 am

  #111252

  I trying writing a cast but I can't seem to get it correct

  cast((Qr_Respuestas / dt.total) * 100 as numeric(10,2))

  The message says "Invalid or missing expression"

  
  Jean-Luc
  www.corobori.com
  

• Mathew J Kulangara

  SSCommitted

  Points: 1610

  More actions

  February 16, 2006 at 8:03 am

  #621376

  What's the entire statement ? There's nothing I can see wrong with the way you cast this.

  test as follows...

  select cast((id/id)*100 as numeric(10,2))

  from syscomments

  ---

  Mathew J Kulangara
  sqladventures.blogspot.com

• Troy Geri

  SSC Enthusiast

  Points: 139

  More actions

  February 19, 2006 at 1:34 pm

  #621916

  Hi

  Try putting the whole calculation in bracket, like this

  select cast(((Qr_Respuestas / dt.total) * 100) as numeric(10,2))

  also you could try

  select cast(((Qr_Respuestas / dt.total) * 100) as decimal(10,2))

  Also, what are the individual fields in the calculation, char,varchar, text??