SQL string problem... take a value, take the ID, search for the ID

[KingJ]

Ok - so how would i use the index on the field name and put that into something that I can actually use. I have tried the Code that Evil suggested no luck