Link to home
Start Free TrialLog in
Avatar of jose11au
jose11auFlag for Australia

asked on

Wildcard Search where names end with three characters

Hi All,

I need your help.

I have a simple query similar to the one below but I would like to modify this query to search for multiple names that ends with the three characters rather than a single search like I have.

Please help.

Many Thanks.

select a.frist_name, a.last_name, a.city,a.state,a.country
from sales_branch a
where a.last_name like 'ith%'

string to search:
sty
wer
ggh
ght
err
rtt
ert
ASKER CERTIFIED SOLUTION
Avatar of crangry
crangry
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jose11au

ASKER

Thanks for for your help crangry. It works!!!

Cheers