سلام من هم از این کد برای جستجو استفاده کردم
ولی موقع نمایش نتیجه جستجو بجای فیلد Ex_Roll علامت سوال نمایش میده
ALTERprocedure [dbo].[pcExSearchnoDate]
@Ex_Name nvarchar(50)=null,
@Ex_Reason nvarchar(50)=null,
@Knd_ID nvarchar(50)=null,
@Ex_Executer nvarchar(50)=null
as
begin
Declare @where nvarchar(max)=''
Declare @select nvarchar(max)=''
declare @true nvarchar
set @select='select Ex_ID,Ex_Name,Ex_Reason,dbo.PersianDate( Ex_StartDate) as Ex_StartDate,dbo.PersianDate( Ex_EndDate) as Ex_EndDate
,dbo.PersianDate( Ex_RecordDate) as Ex_RecordDate,Knd_ID,Knd_Title,Ex_Executer,
Ex_Rol=case Ex_Rol
when(''1'')then N''فعال''
when(''0'')then N''غیرفعال ''
end
,Ex_Number,IsActive
from dbo.view_Exam'
set @true='1'
set @where='IsActive='+@true+' And'
ifnot @Ex_Name isnull
set @where+=' Ex_Name like N''%'+@Ex_Name+'%'' And'
ifnot @Ex_Reason isnull
set @where+=' Ex_Reason like N''%'+@Ex_Reason+'%'' And'
ifnot @Knd_ID isnull
set @where+=' Knd_ID like N''%'+@Knd_ID+'%'' And'
ifnot @Ex_Executer isnull
set @where+=' Ex_Executer like N''%'+@Ex_Executer+'%'' And'
if @where <>''
begin
SET @where=SUBSTRING(@where,0,LEN(@where)- 3)
set @select+=' where '+@where
execsp_executesql@select
end
else
execsp_executesql@select
end