in reply to Re: SQL and Perl comparison
in thread SQL and Perl comparison

In addition, '_' is the SQL equivalent of '.' in Perl regexes. So, 'DDD______%' is equivalent to 'DDD.{6}.*' in Perl. (Note that the two-character token ".*" is equivalent to '%' in SQL, not the one-character token '*'.)

My criteria for good software:
  1. Does it work?
  2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?