Hi needed function for DECODE

• SreenivasaRao

  SSC-Addicted

  Points: 499

  More actions

  November 24, 2005 at 7:07 am

  #88576

  Hi all

  I want migrate my application from Oracle to Ms-sql server

  -frant end having sql promming(Oracle specific)

  i don't want touch that proming part

  in my ms-sql server i want write a function which is replace DECODE -TO - COALESCE

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  November 24, 2005 at 7:30 am

  #605689

  Didn't you ask the same question on another thread

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=234436#bm234839

  Far away is close at hand in the images of elsewhere.
  Anon.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 25, 2005 at 4:43 am

  #605830

  Check this out: http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]