i have to match string like below
i have store cow dog
there is space between them cow-----dog
---this indicate space
when i search like cowdog it will show me that name which hhave space
when i search cowd i
then also it will show me cowdog
i want to write query using scalar function