* as first character

  • Thread starter Thread starter ChrisBat
  • Start date Start date
C

ChrisBat

Hi,

I am trying to run a query that will allow me to pull up
any record that has an asterisk as the first character.
As you can imagine, I get a lot of data back that I don't
need if I use the conventional Like "*" criteria. I have
also tried Like "~*", as this has worked for me in the
past with Excel.
Does anyone have any suggestions? I'm on my third venti
starbucks coffee right now, and it's only 9:30 a.m.!!
Thanks,
Chris
 
Worked like a charm, thank you so much...
Chris
-----Original Message-----
Try:

Like "[*]*"


Hi,

I am trying to run a query that will allow me to pull up
any record that has an asterisk as the first character.
As you can imagine, I get a lot of data back that I don't
need if I use the conventional Like "*" criteria. I have
also tried Like "~*", as this has worked for me in the
past with Excel.
Does anyone have any suggestions? I'm on my third venti
starbucks coffee right now, and it's only 9:30 a.m.!!
Thanks,
Chris
Click to expand...


.
Click to expand...
 
Back
Top