this is some inherited code we have.
SELECT * from data where (datafield like 'ROUTE|CUSTOMERLOCATION')
doesnt seem to work.. i think they were trying to say if data is like route OR like customerlocation
select * from data where (datafield like 'ROUTE') or (datafield like 'CUSTOMERLOCATON')
produces the data we are looking for.
Is there a '|' operator for a like statement?