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/>