Daryl,

Thanks for the reply. Varchar has a limit of 8000 characters. I cannot specify more than that.

I know I can use text data type. But the problem with "text" is...

Thanks Lynn. That worked

I tried that. But I doubt SQL Server will accept that. It gave me syntax error

Sugesh,

Thanks for the reply. I am not sure how to mention both 0 and 1 for the @CaseFlag in the else clause.

Can you please give me an example?

My where...