I have created a dymanic sql string client side for use in a search function, however when I include a % sign in the SQL string the character % is converted to a õ sign by the time it reaches SQL server.<BR><BR>What is causing this? When Response.Write &#039;ing the SQL string to the page it looks like<BR><BR>Select * from Tablename Where (Name LIKE &#039;testõ&#039;) <BR><BR>nb. test is the variable being passed from a form<BR><BR>thanks for any help.