By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [Emp] (
[Name] NVARCHAR(100)
)
INSERT INTO [Emp] ([Name]) VALUES
(N'_#@#_123'),
(N'@#@#@123'),
(N'@#@#_123'),
(N'_#@#_123')
DECLARE @name NVARCHAR(MAX) ='_#@#_1'
--SELECT [Name] FROM [Emp] WHERE [Name] LIKE @name + '%' -- not working as expected
SELECT [Name] FROM [Emp] WHERE [Name] LIKE REPLACE(@name, '_', '[_]') + '%' -- OK
| Name |
|---|
| _#@#_123 |
| _#@#_123 |