Find a value in a field with a string

[f5snopro]

I'm trying to search a field in access that contains server hostnames. For instance, I want to find av3300. A string might have av5500,cad1100,av3300,test1213. I want that application information returned if the av3300 is found.

Ultimately I'm goning to take a list of servers I have, compare it to the list of apps, and output (page by page) what applications run on what servers. Some apps run on multiple servers. I see that relationship as a union.

 

[mpastore]

select * from mytable where myfield like "*av3300*"

Mike Pastore

Hats off to (Roy) Harper

 

[f5snopro]

So simple! I let it pass right by me. Thanks for setting me straight.