Try This :

Create procedure proc1

@orderstatus VARCHAR(15),

@orderdate DATETIME,

@createdate DATETIME

AS

Select * from table1

where ordercreatedt >= CAST(CONVERT(Varchar(10),GetDate()-1,120) AS DateTime)

AND ordercreatedt < CAST(CONVERT(Varchar(10),GetDate(),120) AS DateTime)

and orderstatus = case when @orderstatus = 'ALL' then orderstatus...

Try This

SELECT SubString

( Description,

CharIndex ('[', Description) +1,

CharIndex (']', Description) - ( CharIndex('[', Description) +1)

)

FROM PublishItem

WHERE Description Like '%Doc No%' and Description Like '%[[%]%'