Why it is returning *

• SqlSpider...

  Ten Centuries

  Points: 1254

  More actions

  September 20, 2012 at 1:06 am

  #149458

  hi All,

  when i am executing the below query it is returning * instead of showing error.

  select cast(123 as varchar(2))

  means the length of the integer value is greater than the converting value that time it is showing the result.

  thanks,:-)

• BrainDonor

  SSCoach

  Points: 19254

  More actions

  September 20, 2012 at 1:41 am

  #1539918

  Documented behaviour - http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx#feedback, half-way down the article.

  Steve Hall
  Linkedin
  Blog Site

• SqlSpider...

  Ten Centuries

  Points: 1254

  More actions

  September 20, 2012 at 3:59 am

  #1539961

  Thank you very much