Hi all,

I am trying to do a string search in one of the fields in a table. The way I thought of doing it was using a query. It works okay, though it will only find if the user's search matches exactly what I have in the table. It will not work if I want to find for example everyone that has their names beginning with 't'.

How could I make that possible? I want to find various results from the search, not only if it matches exactly.

:?



"When a boy sits next to a girl for a hour, it feels like a minute. Though, when he sits on a hot stove for a minute, it feels like an hour. That's relativity!"
~ A. Einstein

SELECT * FROM YourTable WHERE YourField LIKE 't%'

If you are ever stuck in access and need something requiring an expression, just go to help and type "expressions". then view "examples of expressions". It is the most helpful info you can get.
In fact, just try it now.



Sal

That helped it. ;)

Thanks guys! I thought that the 'wild card' was the asteristc (*) symbol but no, it is the percentage symbol.

Gotcha!

Hey Sal, you're right. They have many good examples that I can relate to in the help menu. Thanks!

"When a boy sits next to a girl for a hour, it feels like a minute. Though, when he sits on a hot stove for a minute, it feels like an hour. That's relativity!"
~ A. Einstein