Alpha numeric

Hi there,

I am working on a query, I want to filter using alpha and numeric charaters only. Want to avoid alpha or numeric characters. Any help is appreciated.

Thank you

Raj

If you are trying to filter by one field that contains both text and numeric, then the field criteria will be a string. If you are filtering by two separate fields, one is text and the other is numeric at the same time, then your WHERE clause will include And not Or.

Post an example of what you are trying to do.

lwells

Iwells,

I have a field which has mostly addresses like 16502 preston view, texas and then few rows have some thing like deed of trust. So what i was trying to do is in a query give a condition/criteria to filter by alpha + numeric, so that i can get addresses and drop alpha like deed of trust which i do not require.

Hope this makes sense.

Raj

Does Deed of Trust contain alpha and numeric characters as well? Give me an example of what the Deed of Trust will look like and is it consistent in the database, ie., same length of characters, always begins with a certain number or symbol etc.

lwells