Does Rbase allow meta characters to create a regular expression search?

Such as;

UPDATE pri_ins SET i_name = 'RR MEDICARE'
    WHERE i_name LIKE 'MEDICARE%'
    AND i_pol LIKE '[A-Z]%[^A-Z]'

The above should match on any record that matches the i_name MEDICARE
BLABLABLA, and a i_pol that starts with any letter, with any number of
alpha-numeric characters following but not ending with a letter.

If so, is there a list of allowed meta characters?

Thanks in advance!

-- 
John Croson
[email protected]
[email protected]
<http://www.croson.us>  <http://www.twitter.com/pcnorb>
<http://pcnorb.blogspot.com/>   <http://www.linkedin.com/in/johncroson>
<http://www.facebook.com/john.croson>   <http://croson.smugmug.com/>

Reply via email to