I am trying to do a database search on a name that I get from a vb text box. However I'm allowing users to put in a first and last name. In SQL I want the query to include '%John%Doe%'. How do I go about removing the space between John and Doe, and inserting the %?