All Forums Database
rnadjafi 4 posts Joined 06/16
24 Jun 2016
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:
dejo316 5 posts Joined 03/16
24 Jun 2016

col1 col2
3 test one  
1 test two  

1 testthree 

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

rnadjafi 4 posts Joined 06/16
24 Jun 2016

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

dnoeth 4628 posts Joined 11/04
26 Jun 2016

How do you submit it?
Can you show the actual WHERE-conditon?

Dieter

You must sign in to leave a comment.