I have built a program with full SQL functionality (from pulling to adding etc).
I am using stored proceedures for the SQL queries.
I seem to have a problem when adding / updating a SQL VARCHAR column when the item being added / updated has a space (ie 'Add This').
So my question is, what extra functionality do i need to add to allow a string to be added that has more than one word into a single column?
Or do i have to do something like replace the space with an underscore when adding then change it when showing it to the user?
Thanks for your time.