i need to add case statement in dynamic sql for stored procedure

---

BasitNisar wrote:

• I need to add case statement for ClaimnNumber[

---

BasitNisar , your post is badly formatted and so unreadable, contains sometimes only code fragements; no one can work on.

Fix formating and provide much more informations.

Please post table design as DDL, some sample data as DML statement and the expected result.