query for unusual characters

[David Shorthouse]

Hello folks,

I received a db export from something other than Access or SQL Server
(must have been Unix-based or something). Some of the text-based fields
contain unusual characters and I'd like to construct a query to find records
that contain text within their strings other than A-Z. Is this possible? For
example, there may be records like "Sm^th" or "J$hn" and I'd like to query
those. Since there are many records (10,000+) and since there may be many
such unusual characters, this is not as easy as just querying for "*$*" or
"*^*".

Thanks for any ideas,

Dave

--
______________________________
Remove "_SPAM" to reply directly.

[Douglas J Steele]

Like "*[!A-Z]*"

For clarity, that's

Like " * [ ! A - Z ] * "

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"David Shorthouse" <davidshorthouse@shaw_SPAM.ca> wrote in message
news:eB5xCHAf...@tk2msftngp13.phx.gbl...

[David Shorthouse]

Well, that works great! But what if there are some characters in the string
like "&" that I don't mind being included so long as elsewhere in the same
cell there aren't the characters I need to search for.

Thanks again,

Dave

--
______________________________
Remove "_SPAM" to reply directly.

"Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:eErW6NAf...@TK2MSFTNGP10.phx.gbl...

[Douglas J Steele]

To include &, use

Like "*[!A-Z&]*"

To include & and $, use

Like "*[!A-Z&$]*"

To include...well, you get the idea.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"David Shorthouse" <davidshorthouse@shaw_SPAM.ca> wrote in message

news:%23UyySFC...@TK2MSFTNGP14.phx.gbl...