Comparing alphanumeric strings
From: Bani Limaye <limaye_at_ccs.neu.edu>
Date: 1995/05/10
Message-ID: <3orino$d85_at_camelot.ccs.neu.edu>#1/1
Date: 1995/05/10
Message-ID: <3orino$d85_at_camelot.ccs.neu.edu>#1/1
How does one do comparisons on character strings that are alphanumeric and
get the right results?
select char_val from y
returns (incorrectly):
char_val
For example:
where char_val > '711.00'
and char_val < '911.00'
order by char_val;
711.00A
714.00
74.00
900.00
Received on Wed May 10 1995 - 00:00:00 CEST