Finding ascii characters using a query

[netcert]

I'm trying to write a query (in sql view) to find any existing characters outside the 65-122 range. Here's what I have so far but i get no results:

SELECT tblMember.MemberNum, tblMember.LastName, tblMember.FirstName
FROM tblMember
GROUP BY tblMember.MemberNum, tblMember.LastName, tblMember.FirstName
having (tblMember.FirstName not like "chr[65-122]");

Again, I'm trying to search various fields for the existence of any of the characters that aren't alphabetic.

Thanks in advance!

 

[hneal98]

So are you saying that what you have does not work?

 

[netcert]

yes.

It returns everything and practically ignores the chr search.

I want to be able to search any field and have it return any chr code it finds.

This stmt works better but only the 1st position:

select asc(left(firstname,1)) from tblMember

 

[hneal98]

try something like this:


SELECT tblMember.MemberNum, tblMember.LastName, tblMember.FirstName
FROM tblMember
GROUP BY tblMember.MemberNum, tblMember.LastName, tblMember.FirstName
having (tblMember.FirstName Not Like "*[A-Z]" OR [firstname] Not Like "*[0-9]";

 

[PHV]

Like '*[!A-z]*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886