Can the * be selected as a regular character?

[MarketAn]

The subject says it all. I have been given a table of item numbers that are segrigated by * and non-* numbers (ie. 111 and 111*). Is there any way to just select the * numbers? Thank you

 

[tlbroadbent]

You can use the INSTR function.

SELECT TestTbl.*
FROM TestTbl
WHERE InStr([ItemNo],"*&quot>0;
Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[Databaseguy]

Or, in a query, enclose it in brackets

Like Like "*" & "[*]" & "*"

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy