حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Replace string with new at starting (first) position in SQL Server

makumbi

Please help

i have 256782999664

how can i use sqlserver to remove only 256 at the starting point and then add zero to the starting value so that it becomes 0782999664

dharmend...

0 3

Use below query.

SQL

SELECT STUFF('256782999664',CHARINDEX('256','256782999664',1),3,'0')

Output

0782999664

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html