else IF @tabname='FAQ' BEGIN print('hi') SET @SQL = 'SELECT FAQId, FAQStatus,TopicName, TopicRelatesto, dbo.fn_parsehtml(Questions) as Questions FROM '+ @tabname1+' where ' SET @SQL+='IsActive='''+ @IsActive +''' and IsApproved='''+ @IsApproved +''' and FAQStatus=''Y'' and --StateID=(CASE WHEN isnull('+ cast(@StateId as nvarchar(10))+',''0'')=''0'' THEN StateID ELSE '+ cast(@StateId as nvarchar(10))+' end) and -- ActID=(CASE WHEN isnull('+ cast(@ActId as nvarchar(10))+',''0'')=''0'' THEN ActID ELSE '+ cast(@ActId as nvarchar(10))+' end) and '+@DetIdname+'=(CASE WHEN isnull('''+@DetId+''','''')='''' THEN '+@DetIdname+' ELSE '''+@DetId+''' end) and ' SELECT @FINALSQL = @FINALSQL + ' OR [' + SYSCOLUMNS.NAME + '] LIKE ''%' + @txtSearch + '%'' ' FROM SYSCOLUMNS WHERE OBJECT_NAME(id) = ''+ @tabname +'' AND TYPE_NAME(SYSCOLUMNS.XTYPE) IN ('VARCHAR','NVARCHAR','CHAR','NCHAR') ORDER BY COLID set @FINALSQL=RIGHT(@FINALSQL, LEN(@FINALSQL) - 2) set @SQL=@SQL+'('+@FINALSQL+')' PRINT @SQL END