how to filter on data that begins with "PI"

[eeps24]

In design view, how do I filter on my data so that it only shows data that beings with "PI"? Yes I know I can do this by the main screen and say select text that beings with PI but I would like to know how to do it with sql.

thank you

[ranman256]

you do it in the query.
use an asterisk in the field criteria type: PI*
it will change to LIKE 'pi*'

you can do live filters on the form using the full query
select * from table
then filter using a text box txtBox1, and the afterUpdate event

sub txtBox1_Afterupdate()
me.filter = "like '" & txtBox1 & "*'"
me.filterOn = true
end sub

[eeps24]

i think i figured it out....

like "PI%"

[eeps24]

thank you ranman, I think we posted at the same time.

[ranman256]

% only filters 1 character.
* filters EVERYTHING after the PI.

[June7]

Actually % does match any number of characters. https://support.office.com/en-ie/art...9-e18abaad12d1

[eeps24]

Actually % does match any number of characters. https://support.office.com/en-ie/art...9-e18abaad12d1

awesome link! very very helpful