SELECT StillBirth, ReBurial, LiveBurial FROM TCODE_A_BURNNUMBER WHERE USINGSTATUS = \'1\'AND BURN_SEQ = \'011\' AND CHASU_SEQ = \'04\'
여기서
BURN_SEQ 의 \'011\'의값을
\'11\' 로 뽑으려면 어케해야하나요??
안녕하세요.
select ltrim(BURN_SEQ, \'0\') from ... 와 같이 사용하시면 됩니다
>SELECT StillBirth, ReBurial, LiveBurial FROM TCODE_A_BURNNUMBER WHERE USINGSTATUS = \\\'1\\\'AND BURN_SEQ = \\\'011\\\' AND CHASU_SEQ = \\\'04\\\'
>
>여기서
>BURN_SEQ 의 \\\'011\\\'의값을
> \\\'11\\\' 로 뽑으려면 어케해야하나요??