I'm searching my many SQL books, but this eludes me, and I was sure
there was a syntax for it. I want to send out a select statement that
finds every string in a field that is essentially larger than (or
smaller than) a globbed string.
This "... where version_label >= BLD_1*" would return:
BLD_1.0
BLD_1.1
BLD_1.2
BLD_1.4
But not:
BLD_0.9
For some reason the keyword "LIKE" is rattling around in my head, but I
can't find any support for this. Do I have to do this programatically?
--
Lan Barnes lan@falleagle.net
Linux Guy, SCM Specialist 858-354-0616
Tcl/Tk Enthusiast