question

Hi!

Can anybody help translating this Oracle SQL to something that runs on Microsoft SQL-server?

Best regards, Brian

The code:

UPDATE individ c
   SET (c.z_linie2, c.z_linie3, c.z_linie4) =
	(SELECT SUBSTR(   v.z_vejnavn || ' '
	       || DECODE(c.husnr,
			 NULL, DECODE(c.bnr,
				      NULL, '',
					    'B-' || LTRIM(c.bnr,'0')),
			       LTRIM(SUBSTR(c.husnr,1,3),'0')
			       || DECODE(SUBSTR(c.husnr,4),
					 NULL, '',
					       ' ' || SUBSTR(c.husnr,4)))
	       || DECODE(LTRIM(c.z_etage,' '),
			 NULL, '',
			       ',' || LTRIM(c.z_etage,'0'))
	       || DECODE(LTRIM(c.z_sidedoer,' '),
			 NULL, '',
			 'mf', ' mf',
			 'th', ' th',
			 'tv', ' tv',
			       ',-' || LTRIM(c.z_sidedoer,' 0')),
	  1,34),
	v.z_bygde,
	v.postnr || '  ' || p.z_postdr
   FROM postnr p, vej v
  WHERE (c.vejkod = v.vejkod )
    AND (c.komkod = v.komkod )   
    AND (v.postnr = p.postnr (+)))
where c.pnr in (select l.pnr FROM ladropl2010 l
	  	where  l.lseq BETWEEN &fra AND &til )
AND c.komkod like '9%'