Regular expressions SQL replacement

Is there a way to use LINQ technology to search in a text string?
Regular expressions are in my opinion not very intuitive.
Something along the lines of

From astring
Select WORDS
where WORD like '%hello%'

or

From astring
Select WORDS
where WORD startswith '<' AND WORD endswith '>'

WORD being a special keyword
I suppose there could be other keywords such as SENTENCE or NUMBER

[428 byte] By [christmm] at [2008-2-16]
# 1

Perhaps

from word in astring.Split(" ")
where word.StartsWith("<") and word.EndsWith(">")
select word

...?

KeithFarmer at 2007-9-9 > top of Msdn Tech,Visual Studio Orcas,LINQ Project General...
# 2

not all words are space seperated. It might be a full stop , comma or tab.
I am thinking more along the lines of a proper parser.

christmm at 2007-9-9 > top of Msdn Tech,Visual Studio Orcas,LINQ Project General...
# 3
nonetheless.. just replace split with your generator-of-choice, and the pattern should hold
KeithFarmer at 2007-9-9 > top of Msdn Tech,Visual Studio Orcas,LINQ Project General...

Visual Studio Orcas

Site Classified