select query

[Frank]

I want to select records from a table where the text of a particular field contains "KB"

for example idfield = "KB1234" Or "KB34567"

I wouldn't want records containt "BC1234" etc

any help would be appreciated.

 

[Van T. Dinh]

SELECT *
FROM YourTable
WHERE [IDField] Like "KB*"