View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default how to create a wildcard in MSQuery

You can use the % character, e.g.

Like '%manager%'

Grd wrote:
Hi there,

I'm using MS Query in Excel to connect to an excel file and analyse it. I
tried using the * for wildcard characters but it didn't work.

ARe wildcard characters supported.

Thanks you in advance

Suzie



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html