Pages

Tuesday, March 14, 2017

Update SQL with LEN

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'

No comments:

Post a Comment

Give me feedback.