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.
That's not working for me. Somehow it trims the space.
How do you submit it?
Can you show the actual WHERE-conditon?