Where clause issue

[GOVMATE]

Hi I'm new to query writing and I'm needing help with a query that will search a field that either contains a name or an address and only return fields with addresses.

Select address1
From Booktable,
Where (Left([address1],1) = Like "[A-Z]"


Thanks in advance for any help!

 

[CraigDolphin]

Try something like:

SELECT Booktable.address1
FROM Booktable
WHERE (((IsNumeric(Left([address1],1)))=False));

If this is a reworded repost of the other thread then please delete one or the other.

 

[GOVMATE]

Try something like:

SELECT Booktable.address1
FROM Booktable
WHERE (((IsNumeric(Left([address1],1)))=False));

If this is a reworded repost of the other thread then please delete one or the other.

Thanks Craig I will try what you're suggesting. I was able to get the following to work

SELECT address1
FROM Booktable
WHERE (Left([address1],1) Like "[0-9]");

Thanks again!!!!!!!!!!