Re: How ">=" Work on Varchar field?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 09:32:10 -0500

No, this has absolutely nothing to do with ASCII.

It finds all the values that are alphabetically "greater" than 'value1' e.g.
value2, valve, veil but not val or vail.

Whether it will treat value1 = Value1 depends on the collation of the column
or database, same goes for accented characters or other symbols outside the
general set of alphanumerics. 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Prabhat" <not_a_mail@hotmail.com> wrote in message
news:#wLgPgOwEHA.3012@TK2MSFTNGP10.phx.gbl...
> Hi All,
>
> Suppose I will use
> Where col1 >= 'value1'
>
> and the col1 is a varchar - Indexed column, then how does the >= works on
> that Case?
>
> Does that take the sum of the ascii value of all characters of value1 and
> find all rows with > value then the sum and display, or how?
>
> Thanks
> Prabhat
>
>

Relevant Pages

  • Finding a Range of Unicode Characters
    ... When I imported data into FM from another database program, some of the accented characters were changed into other ASCII or Unicode symbols. ... Is there any way I can do a find in a field to locate all records with any characters or symbols above the ASCII or Unicode range of standard English letters and punctuation marks without having to do separate finds for each individual symbol? ...
    (comp.databases.filemaker)
  • Re: How ">=" Work on Varchar field?
    ... uses the Ascii for all Characters in the Word to Compare. ... Want the output order by Lastname, ... > find all rows with> value then the sum and display, ...
    (microsoft.public.sqlserver.programming)
  • Unicode: matching a
    ... I'm working with Unicode strings to handle accented characters but I'm ... the latter doesn't match accented characters. ... obvisouly all be converted to ascii. ...
    (comp.lang.python)
  • Re: Saving Lisp data
    ... Preliminary tests w/ CL-STORE vs. READ/PRINT are favorable. ... The sum of ... But I'll grant you that, in general, ASCII can be better than binary. ... I'm processing large arrays of 32-bit pixel data. ...
    (comp.lang.lisp)
  • Re: How ">=" Work on Varchar field?
    ... For getting the alphabetically greater that has to find that using the Ascii ... > There's no summation here. ... > Columnist, SQL Server Professional ... > find all rows with> value then the sum and display, ...
    (microsoft.public.sqlserver.programming)