finding a comma and characters between a space in a field

[johnmerlino]

Hey all,

I'm trying to figure out how to find a comma in a field or the characters " TR ", " LIV ", or " REV " (notice the spaces between tr, liv, and rev). Right now I try this and get "syntax error missing operator in query expression".

SELECT *
FROM contacts
WHERE
(
contacts.names_1 Like "*" & , & "*"
Or
contacts.names_1 Like "*" & TR & "*"
Or
contacts.names_1 Like "*" & LIV & "*"
Or
contacts.names_1 Like "*" & REV & "*"


)
OR
(
contacts.names_1 Like "*" & , & "*"
Or
contacts.names_1 Like "*" & TR & "*"
Or
contacts.names_1 Like "*" & LIV & "*"
Or
contacts.names_1 Like "*" & REV & "*"
)
)
;

[ajetrumpet]

I'm trying to figure out how to find a comma in a field or the characters " TR ", " LIV ", or " REV "

why not just use INSTR()??

SELECT  *
FROM contacts
WHERE  

instr(contacts.names_1, " TR") > 0 OR
instr(contacts.names_1, " LIV") > 0 OR
instr(contacts.names_1, " REV") > 0 OR
instr(contacts.names_1, ", ") > 0

[slave138]

Just a small correction to match his description better:

SELECT  *
FROM contacts
WHERE  
 
instr(contacts.names_1, " TR ") > 0 OR
instr(contacts.names_1, " LIV ") > 0 OR
instr(contacts.names_1, " REV ") > 0 OR
instr(contacts.names_1, ", ") > 0

Added spaces after TR, LIV & REV

[weekend00]

Hey all,

I'm trying to figure out how to find a comma in a field or the characters " TR ", " LIV ", or " REV " (notice the spaces between tr, liv, and rev). Right now I try this and get "syntax error missing operator in query expression".

SELECT *
FROM contacts
WHERE
(
contacts.names_1 Like "*" & , & "*"
Or
contacts.names_1 Like "*" & TR & "*"
Or
contacts.names_1 Like "*" & LIV & "*"
Or
contacts.names_1 Like "*" & REV & "*"
)
OR
(
contacts.names_1 Like "*" & , & "*"
Or
contacts.names_1 Like "*" & TR & "*"
Or
contacts.names_1 Like "*" & LIV & "*"
Or
contacts.names_1 Like "*" & REV & "*"
)
)
;

Are the red part same as green part?

[slave138]

Are the red part same as green part?

Now that you mention it...

I was so busy looking at the syntax problems that I didn't even notice the redundancy.