Question:
How do you select all entries that contain a certain substring? Is there a function like InStr() in VB?
Answer:
Yes, Check out the charindex function which will Return the number of the position the charcter searched for occupies in the searched for expression. Try this in Pubs:
select charindex("B", title_id) from titleauthor--------------------- 111111000000
