Hi can any one help me in solving the problem if I'm having an entry that has a single collon (')...

when im retrieving it in a query and the data has a single collon (e.g. Jayson's Shift), it returns an error. Yes bcs the query has an odd number of collon, So if anyone experince this problem, pls share me the solution.
Thanks