I am trying to trim the white space form between two words in a txt box. The reason for this is i want to run a query to check the db for a match. What happens now is lets say i type mike Jones in the textbox and run my query it find it. but if theres any more than one space between mike and Jones my query returns as no match.
Thanks for any help