Locate Specific Words in a Description

[net]

Hello,

I hope this is not too complicated. I have very little experience in SQL, so I am hoping this does not require SQL code. 

I am working with a Microsoft Access query and in the query design I am trying to find in a description field (Short text) all records that has the word RRUxxxxxx in the description field. So, I need to display that entire description with the word RRUxxxxxx. I know the wild card will pick-up the remaining text, but I cannot get it to work.

Sample Data:

Description

RRU35992 is provided in the hub of the base unit...

I am using in the query design criteria Like “*RRU*”, but I am not getting any data. 

Appreciate your help. I have been working on this most of the day and I am very frustrated!!

 

[Ranman256]

That should work. It does not work in a memo field. But you said short text. Not the same correct?

 

[net]

Hi,

I appreciate the prompt response Ranman.

Yes, it is a Short Text field. The data is not returning. I know it is in there because I did a raw dump to Excel and searched for "RRU" and received several rows returned.

 

[net]

I apologize, I had the wrong sample description.