PRESERVING A SPACE IN A LIKE STATEMENT

Database

PRESERVING A SPACE IN A LIKE STATEMENT

How do you preserve the space in a LIKE statement (% WORD1%)?  Any assistance you can provide would be greatly appreciated.

Tags (1)
3 REPLIES

Re: PRESERVING A SPACE IN A LIKE STATEMENT

col1 col2

3 test one  

1 test two  

1 testthree 

sel * from sampletbl where col2 like '%test %' only retrieves the first two rows.

Re: PRESERVING A SPACE IN A LIKE STATEMENT

That's not working for me.  Somehow it trims the space.  

N/A

Re: PRESERVING A SPACE IN A LIKE STATEMENT

How do you submit it?

Can you show the actual WHERE-conditon?