Link to home
Start Free TrialLog in
Avatar of twittoris
twittoris

asked on

Multiple LIKE statements

Is it possible to perform multiple like statements on one cell?
For example, lets say there is data the was aggregated and sometimes words are abbreviated (SUITE or STE, STREET or ST)

So the like statement would be $var + S% + P%
Could equal:
$var sullivan Place

Or do i have to do something with nested if statements to determine the layout?
Avatar of mattibutt
mattibutt
Flag of United States of America image

you can use case it will much clear and readable
Avatar of twittoris
twittoris

ASKER

Can you give me an example in php?
For a question like this one, we really need you to show us your test data and your desired results.  We can help you bridge the gap, but we can't make up logic from an approximate description.
ASKER CERTIFIED SOLUTION
Avatar of ashokadi
ashokadi

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