One suggestion is to add the upper to both side of the comparision to make it work with case senstive databases.

Ex: where upper(text) like upper(@searchstring)