Functions to use instead of to_char in SQL Server 2000

• anitha.chacko

  SSC Veteran

  Points: 243

  More actions

  December 7, 2010 at 10:11 pm

  #231907

  Hi,

  I need to change the following oracle statement equivalent in SQL Server 2000.Please help me

  substr(to_char(fee.rollno,1,2)=substr(to_char(batchcode),1,2)

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738043

  More actions

  December 7, 2010 at 10:19 pm

  #1259904

  Use CAST or CONVERT for to_char to convert data to strings.

• anitha.chacko

  SSC Veteran

  Points: 243

  More actions

  December 7, 2010 at 10:28 pm

  #1259906

  Can u please tell me how to convert it exactly

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  December 7, 2010 at 11:24 pm

  #1259917

  anitha.chacko (12/7/2010)

  ---

  Can u please tell me how to convert it exactly

  http://msdn.microsoft.com/en-us/library/ms187928.aspx

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738043

  More actions

  December 8, 2010 at 8:54 am

  #1260141

  I don't know exactly what to_char will do on Oracle, so no, I can't. I have pointed you to the similar commands, and there is a link from someone to help you work through it.

  SUBSTRING in SQL Server will get part of a string. CAST will change the type to a character. I assume they are drop in replacements for that code, but YOU have to test it and make sure it acts as you expect.