sp_executesql full text search and wild cards

Convert the * to its ascii value before its passed, and back again after.

select ascii('*'), char(42)