* as first character

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
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slideshow with black border around it 0
How to paste this down? 3
Autocopy the first cell with more than 30 characters to a different sheet? 1
Word isn't capitalizing the first word of each sentence 2
query to show where no data in a stated column 0
Query for # character not working 2
Include first 3 characters in results 5
Repeated Character 0

Top