T
Toni
I need to match a string in a database, but ignore any trailing punctuation such as a
period, exclamation point, or question mark.
for example,
SELECT * FROM tbl_stuff WHERE phrase = term
So, if row 5 of the database contains phrase="This is great and exciting!"
and term = "This is great and exciting" (no trailing exclamation point),
it will match row 5.
But if term = "This is great", it will not match.
Can anyone please help?
Thanks!!!
period, exclamation point, or question mark.
for example,
SELECT * FROM tbl_stuff WHERE phrase = term
So, if row 5 of the database contains phrase="This is great and exciting!"
and term = "This is great and exciting" (no trailing exclamation point),
it will match row 5.
But if term = "This is great", it will not match.
Can anyone please help?
Thanks!!!