Hi Leon,

Great article. I thnk even this solution would work:

IsNull(state,'') like IsNull(@State,'')

Or

state like IsNull(@state,state)+''

I am using this in a procedure and it seems to work fine.