PDA

Click to See Complete Forum and Search --> : [RESOLVED] Query an Asterisk


fEtchboi88
May 14th, 2009, 07:34 AM
This isn't really a visual basic question, and it's probably really easy, but how can you run a query in Access for fields with an asterisk (*) in it. It keeps treating * as a wildcard and giving me the entire table.

brucevde
May 14th, 2009, 09:14 AM
Wrap the asterisk in square brackets.

Like " *" - Starts with *
Like "* *" - Contains a *
Like "* " - Ends with *

fEtchboi88
May 14th, 2009, 09:45 AM
haha i knew it was something simple.

Thanks dude.