I'm using a stored procedure on a autocomplete dropdownlist to retreive a list of clients. Some of the clients have an '&' (ampersand) sign in the name e.g. 'H&M', 'Marks & Spencers' and users would like to search on the '&' sign.

When i directly use the & sign it uses it as a word breaker and does not pick the list which has '&' sign.

Is there any way i could search the table using the '&' and retreive values that have '&' sign.

Hope i've made sence explaining what i need to do.

Thanks for all your help!