NULL to Empty

[jdmurcia]

In and stored procedure, how can I change any null result to empty?

In other words, select both: null and empty records when the query includes WHERE Field LIKE '%' (my condition LIKE '%' excludes NULLs)