Dears,
I have an issue i don't understand
i have this table
CREATE TABLE [Security].[ServiceOperations]
(
[ServiceOperation_ID] [bigint] IDENTITY(1, 1)
NOT NULL ,
[ServiceContract_ID] [bigint] NULL ,
[OperationName] [nvarchar](MAX) NULL ,
[Name_Ar] [nvarchar](MAX) NULL ,
[Name_En] [nvarchar](MAX) NULL
)
with these data
SET IDENTITY_INSERT [Security].[ServiceOperations] ON
GO
INSERT [Security].[ServiceOperations] ([ServiceOperation_ID], [ServiceContract_ID], [OperationName], [Name_Ar], [Name_En]) VALUES (1, 1, N'DGIT.Business.Entities.DMS.StoredFile GetFile(Int64)', N'جلب الملف من خلال رقم الملف', N'Return file from file id')
GO
INSERT [Security].[ServiceOperations] ([ServiceOperation_ID], [ServiceContract_ID], [OperationName], [Name_Ar], [Name_En]) VALUES (2, 1, N'DGIT.Business.Entities.DMS.StoredFile[] GetFiles(System.Guid)', N'جلب الملف من خلال الرقم المرجعي', N'Return file from file Guid ID')
GO
INSERT [Security].[ServiceOperations] ([ServiceOperation_ID], [ServiceContract_ID], [OperationName], [Name_Ar], [Name_En]) VALUES (3, 1, N'Boolean Delete(Int64)', N'حذف ملف من خلا رقم الملف', N'Delete file by file ID')
GO
INSERT [Security].[ServiceOperations] ([ServiceOperation_ID], [ServiceContract_ID], [OperationName], [Name_Ar], [Name_En]) VALUES (4, 1, N'Int64 CreateUpdate(DGIT.Business.Entities.DMS.StoredFile)', N'انشاء او تعديل ملف ', N'Create or Update file')
GO
INSERT [Security].[ServiceOperations] ([ServiceOperation_ID], [ServiceContract_ID], [OperationName], [Name_Ar], [Name_En]) VALUES (5, 1, N'Int64 GetCount(DGIT.Business.Entities.DMS.StoredFile)', N'جلب عدد الملفات', N'Get files count')
GO
INSERT [Security].[ServiceOperations] ([ServiceOperation_ID], [ServiceContract_ID], [OperationName], [Name_Ar], [Name_En]) VALUES (6, 0, N'[][][][]', N'', N'')
GO
SET IDENTITY_INSERT [Security].[ServiceOperations] OFF
when i query for a record using like
SELECT * FROM Security.ServiceOperations AS so WHERE OperationName LIKE 'DGIT.Business.Entities.DMS.StoredFile[] GetFiles(System.Guid)'
its not returning data cause of the '[]' but its returning using '=' operator