Remove Dash SQL Statement

 Ini Koding SQL Statement untuk buang dash dalam IC :

 declare @ICNO as NVARCHAR(14)

 SET @ICNO=’770902-14-5083′

 select substring(@ICNO,0,7) + substring(@ICNO,8,2) + substring(@ICNO,11,4)

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>