Hello,
I'm trying to utilize full text indexing to speed up a function. Right now I have a condition that looks like this:
WHERE Subject like '%E[0-9][0-9][0-9][0-9][0-9][0-9]%'
Ultimately I'm trying to find Emails with anything in the Subject that looks like Exxxxxx (all our Event numbers start with "E" followed by 6 digits i.e. E123456)
Is there an equivalent to the statement above using CONTAINS or FREETEXT? I've tried using this and I am getting results but I don't believe they are correct results because they are different than what is returned using the Like condition above:
FREETEXT(Subject, 'E[0-9][0-9][0-9][0-9][0-9][0-9]')
Thank You,
Lina