[thorny]

Hi, whats the code i can use?? say I have a input box in a form and when a button is pushed it runs a a query and that query takes what the user has inputed and search the databse for the details matching the input. Now I have it all set up but the query runs using input but it must be the exact word and spelling to find the details. What code can i use in SQL in the query to make the query find anything similar. eg input = Jo, query finds details matching= jo, joanna, john etc HELP!!!

[frog]

well i just know a liitle bit of sql but i suupose this would work

SELECT *
FROM table
WHERE name LIKE "jo%";