Check if string ends in a letter

[Vexorg]

Hi,

I am querying account numbers from a column called 'Trade Ref'. I would like to find all rows where the 'Trade Ref' ends in a letter, how do I do this?

 

[alansidman]

In the criteria for the field Trade Ref, place the following:

Like *"[a-z]"

Alan

 

[xenou]

One way:

SELECT 
	Table1.[Trade Ref]
FROM 
	Table1
WHERE 
	((Asc(UCase(Right(NZ([Trade Ref]),1))))>64) 
	And 
	((Asc(UCase(Right(NZ([Trade Ref]),1))))<91)
	;

Assuming the table name is Table1 - edit as needed.

ξ

Edit:
^^ dope. Much better in Alan's post. I always forget you can use character classes with Access wildcards.

 

[Vexorg]

Thanks a lot guys!