Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Function to remove pattern occurences in a string
CREATE Function [dbo].[RemovePattern](@Target NVARCHAR(1000), @Pattern NVARCHAR(100)) Returns NVARCHAR(1000) AS Begin While PatIndex(@Pattern, @Target) > 0 Set @Target = Stuff(@Target, PatIndex(@Pattern, @Target), 1, '') Return @Target End GO select dbo.RemovePattern('0000100001', '0%')
run
|
edit
|
history
|
help
0
Turn column into string
T-SQL CRUD procedures auto-generator
db3
adbms 0
Alquileres
comparison and logical
Test if a string can be made with substrings!
Common Table Expression
SQL Server - NULL values with IN and NOT IN (Solution)
BRYAN_BD1