Re: Comparision on Char Column With Alphanumeric Values

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steve Kass (skass_at_drew.edu)
Date: 11/02/04 

Date: Tue, 02 Nov 2004 11:16:49 -0500

IF '43299AAAAAAAA' <= '4329999999999' collate SQL_EBCDIC273_CP1_CS_AS
PRINT 'True'
ELSE
PRINT 'False'

I have no idea what the EBCDIC collations do in detail, but they at
least answer this question to the poster's satisfaction.

SK

Dejan Sarka wrote:

>I guess there must be some sort order where alfa characters have lower ASCII
>number that numbers.
>
>
>