Hi guys, i want to share Update SQL with LEN :
update [DB_Staging].[dbo].[LedgerJournalTrans]
set BIT_LEDGERDIMENSION = SUBSTRING(BIT_LEDGERDIMENSION, 1, LEN(BIT_LEDGERDIMENSION)-2)
where BIT_LEDGERDIMENSION like '%M1'
update [DB_Staging].[dbo].[LedgerJournalTrans]
set BIT_LEDGERDIMENSION = SUBSTRING(BIT_LEDGERDIMENSION, 1, LEN(BIT_LEDGERDIMENSION)-2)
where BIT_LEDGERDIMENSION like '%M1'
0 comments:
Post a Comment