samenvoegen string

• dirk.gistelinck

  Newbie

  Points: 9

  More actions

  July 27, 2016 at 2:42 am

  #320185

  Vrienden

  veld database is like this 45017_2016_B20160004.pdf

  On base of data from other table, i want to create this field. Two probloms :

  how do you this en how can you make that 0004 four chars is because data has length from 1 to 3 chards

  select convert(char(4),EIGREF_JAAR) from dbo.CV1_RODOSSIERBIS where REGISTERJAAR > 2014 AND BESLIS_GEM like 'vergunning' and D_BESLIS_GEM > '2016-01-01' AND CODE_PROCEDURE like 'ASTVER2009' order by SEK_DOSSIER

  select convert(char(4),EIGREF_Nummer) from dbo.CV1_RODOSSIERBIS where REGISTERJAAR > 2014 AND BESLIS_GEM like 'vergunning' and D_BESLIS_GEM > '2016-01-01' AND CODE_PROCEDURE like 'ASTVER2009' order by SEK_DOSSIER

  code must 45017_EIGREF_JAAR_BEIGREF_JAAREIGREF_Nummer.pdf