Querying for values that end in #

[BullwinkleTMoose]

I am trying to write a query against a table that contains product codes. Most of them are numeric (00001), but some end in an alpha (00001_A) or a character (00000_#)



When I try to query for the codes that end in #, I am having a problem.

If I use a wild card in my query (*# or Like "*#"), I am getting all of the values that end with a number but not the ones that ends with #.

Is there a trick to writing my query to just return the values that end in #?

[aytee111]

Right([Field1],1)=Chr(35)

[ssanfu]

I was able to use this query

SELECT tblYourTableName.ProductCode
FROM tblYourTableName
WHERE (((InStr([ProductCode],"#"))>0));

but thought there must be a better way.

Since the hash mark is a delimiter in Access, I found adding brackets tells Access to search for the hash as a text character. (This will work for any special character)

SELECT tblYourTableName.ProductCode
FROM tblYourTableName
WHERE tblYourTableName.ProductCode Like "*[#]";

Change "tblYourTableName" to the name of your table.......