I've used UltraEdit ($50 at UltraEdit.Com) for years. You can get a free
trial, and for slightly more than the $50 you can pay once for all
future upgrades. It's part of a family of products such as UltraCompare.
I've used it for so long that it's hard to tell you why I like it better
than others. But one feature I definitely like is that you can create
language definitions (my term) that instruct the program on how to
highlight reserved words for various languages. It comes with several
loaded and you can add/download your own. In addition to SQR, I also
added PeopleCode.

At Boise State, we use SQLExpress. We are very happy with it.
Here are some of the features we really like:
- It has database access--so it will easily create sql and select
statements for you
- The ability to create our own templates which make writing an SQR much
quicker, and helped us to standardize them easily
- It has a syntax checker that interfaces with the database--so you
aren't just checking the SQR language syntax, it also checks your table
names and references to make sure they are correct.
- One button click to get the procedure flow
- Easily find variables and go to procedures (no more scrolling up and
down the program looking for stuff).
- A great grepp ability (also useful for cobol and other text files).
- A good compare utility (that is useful for any text files--except word
docs).
- Works for more than just SQR.
- Can run SQR from within the program--if you have PSFT permissions to do
so.

And no, I'm not associated in any way with SQRExpress (or whoever sells the
software). :-) We just really liked the fact that when we started using
this program, our time spent working on SQR's went down about half.
deno

It's not got the integrated SQR support that SQLExpress offers, but it's a
decent competitor for UltraEdit. In fact pretty much everything that
UltraEdit does, Notepad++ does also, like Syntax Colour Highlighting for
different languages, code folding etc. The only feature that isn't as good
as UltraEdit is the column edit mode.

First of all thanks to all for the informative info on SQR Editors. So
far it looks like there are 3 choices - SQR Express (149.00 + yearly
maintenance contract of 20%), Ultra Edit ($50.00 one time fee) or Notepad++
(free). Feature by feature SQR Express seems impressive but to costly.
I spend anywhere from 5-15% of my time modifying and developing SQR and
day by day it seems I'm spending less time developing SQR, mostly
modification to existing code. So, is it worth spending the one time cost of
$149.00 and maintenance cost of $30/yr!!! or go with other choices.
What would you choose if you were in my shoes!!! Need your friendly
suggestion...

Some of the other features of SQRExpress are: access to tables and table
structures, ability to access all functions with descriptions (using the
function key) and when you get the function, you can easily insert it into
the SQR (and it will automatically get the statement for the SQC). You can
create SQL select, insert, and update statements using the wizard (including
assignments of variables). You can easily get a printout of the structure of
the SQR. There is a push button which will give you all the variables (so
you don't have to look them up). Drop down access to each procedure so you
aren't scrolling up and down, or having to use a search to get to the right
place. Right click on a procedure name to find other references to it or to
open the procedure. Ability to create your own dictionary of your custom
functions.
I don't know Notepad++. Previously I used Edit Plus--which I liked, but
SQRExpress has cut my time in SQR in half. Not a bad tradeoff.
deno

We use Crimson Editor (www.crimsoneditor.com). It's freeware, and it has an SQR template available that will recognize and color-code your SQR code, making it easier to spot begin/end selects, pairs of parenthesis, DO statements, etc. It doesn't have the power of SQR Express, but we have found it very useful and workable. It also can have multiple files open at one time, remembers which files were open when the application was closed and re-opens them when starting the app. the next time. It also has templates for a number of other languages.