Select statement Using the like keyword

[Mr Oizo]

Hi. I am trying to figure out how to write a select statement that will retrieve all entries that have a certian letter combination in. EG: If the user enters "a" it will retrieve all words starting with an "a". if he enters "ad" it will return all words stsrting with "ad" etc. Please advise :)

[A Wong]

Select * from Table Where Field like 'a%' Select * from Table Where Field like 'ad%' Is that what you are asking for? If it is, you might want to google next time before you ask, it's pretty basic.