AnsweredAssumed Answered

SQL Like Function not working! Help

Question asked by jbourget on Nov 11, 2014
Latest reply on Nov 11, 2014 by jbourget

Hello all,

 

I am having a hard time using the Like function within the Select Attributes feature of my Attributes table. The expression that I typed in is being verified as correct however, it is coming up with no results. [Unit_Name] LIKE '*Limestone*'  is the expression that I am using. However, even though there are many records that have the word limestone in it, it says that there are 0 results. I tried [Unit_Name] ='*Limestone*'   and this seems to work fine, but when I use like it doesn't.. any suggestions?

Outcomes