I need your assistance to find word from text file and get the all latter.

I have my code as it is working fine but I need to continue to search on the all text not only when it find the value.

my query is below

```
SELECT [test].Contents, [test].Subject, Mid(Contents,InStr(1,Contents,"KB"),9) AS KBs
FROM [test]

```

so the value should like KB5212512
Now I need to get the all value in the text not only the first result. Thanks