How do you preserve the space in a LIKE statement (% WORD1%)? Any assistance you can provide would be greatly appreciated.
3 test one
1 test two
sel * from sampletbl where col2 like '%test %' only retrieves the first two rows.