Cast erroring

• SqlSavy

  SSCarpal Tunnel

  Points: 4065

  More actions

  May 17, 2012 at 4:45 am

  #274235

  I'm new to development below script is erroring any idea why?

  select cast(right(@@servicename,2) as int)

  Thanks in advance

• Ant-Green

  SSC Guru

  Points: 113446

  More actions

  May 17, 2012 at 4:47 am

  #1488903

  if you do SELECT RIGHT(@@SERVICENAME,2) what do you get?

  typically in a default instance it will be ER, so trying to put characters into a number wont work.

• SqlSavy

  SSCarpal Tunnel

  Points: 4065

  More actions

  May 17, 2012 at 4:53 am

  #1488906

  thanks!