you might be able to do this with patindex...unfortunately MS-SQL
doesn't have a robust regular expression engine.
perhaps something like....
this_title like '%mysearchstring%'
and patindex('%[A-Z,a-z]mysearchstring%', this_title) = 0
and patindex('%mysearchstring[A-Z,a-z]%', this_title) = 0
(that is a guess at the syntax...better to google or look in books online)
-jim
On 1/25/06, Protoculture <[EMAIL PROTECTED]> wrote:
> I need to do a text search within a query , however... I need to state in the
> query to not accept any letters from [a-z] or [A-Z] directly before and after
> the string to be searched.
>
> example:
>
> where this_title like '%myearchstring%'
>
> where % = [ match any characters except a-z ]
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230404
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
