1. Replace
REPLACE(OrderId, 'FE', '')
2. Stuff
stuff(<org_text>,<from>,<to>,<str to insert instead>)
select OrderId, stuff(OrderId,1,1,'') as stuff_OrderId from CI_Order
REPLACE(OrderId, 'FE', '')
2. Stuff
stuff(<org_text>,<from>,<to>,<str to insert instead>)
select OrderId, stuff(OrderId,1,1,'') as stuff_OrderId from CI_Order
No comments:
Post a Comment